Copy a line with a specific key word into another sheet.
Hello all,
I have been working on a worksheet that I will use as a log, and to complete it I would like to copy a line with a specific key word into the corresponding sheet.
I have 5 sheets in my workbook (the main database named "log", "Bill", "Tim", "Marty", and "Dave").
When their name appears in the engineer column which is column D, I would like it to automatically copy the line into their respective sheets.
How can I set this up?
Many thanks in advance!
Nikki
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Thank you so much patel45 you are my hero!!!It works perfectly!
Hi, kkihead,
maybe like this:
@patel:Please Login or Register to view this content.
should it be
as this line is within the With-Statement?Please Login or Register to view this content.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello HaHoBe,
I tried yours and it said script out of range. Was I meant to change any of the values?
patel45's worked great but I am wondering if there is a way for the sheets to update automatically as something is entered?
Anytime I change anything in the log, I will have to delete what is in each sheet and run the macros again for them to be updated without a bunch of duplicate lines.
Hi, kkihead,
regarding the run-time error (my bad I didnīt update the code accordingly):
This code will take away the line from sheet Log. The other way is (as you mentioned) clear contents on all named sheets prior to running the macro, I wouldnīt take the Workjsheet_Change-event to trigger the macro after a change but use the Worksheet_Deactivate - you would need to activate any other sheet to view what has been copied.Please Login or Register to view this content.
Ciao,
Holger
Last edited by HaHoBe; 08-22-2013 at 01:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks