copy selected rows to second worksheet (NOT Cut + Paste)
Let's say you mark the rows you want by placing an "X" in column A. To pull
column B of selected rows, could do this array* formula:
Copy this over to the right as needed, and then down far enough to allow the
maximum amount of entries. If you are splitting this over multiple sheets,
and a set amount (say 100) entries go on first sheet, modify as so:
*Array formulas must be confirmed using Ctrl+Shift+Enter, not just Enter.
"gyrra" wrote in message
I am trying to create a simple tool log that also incorporates a sign
sheet as a second worksheet.
What I want is to be able to select (not using cut + paste) several rows
by simply being selected on "tool list" worksheet, temporarly copied into
"sign_in" and "sign_out" worksheets.
I need the data selected from sheet 1 "tools list" to fill rows (starting
20) of the next 2 sheets, and then end user simply prints needed sheet,
employee to sign.
This allows me to select only the tools that that employee is checking
in/out at that time and print that list from a second (or third) sheet
with data in previous 20 lines.
I would prefer to be able to keep this workbook protected, but it is not a