Thread
:
copy selected rows to second worksheet (NOT Cut + Paste)
View Single Post
#
3
June 4th, 2010, 09:05 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
Posts: 607
copy selected rows to second worksheet (NOT Cut + Paste)
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"gyrra" wrote in message
...
I am trying to create a simple tool log that also incorporates a sign
in/out
sheet as a second worksheet.
What I want is to be able to select (not using cut + paste) several rows
and
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
at
20) of the next 2 sheets, and then end user simply prints needed sheet,
for
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
along
with data in previous 20 lines.
I would prefer to be able to keep this workbook protected, but it is not a
nessessity.
Don Guillett[_2_]
View Public Profile
View message headers
Find all posts by Don Guillett[_2_]
Find all threads started by Don Guillett[_2_]