Hi all,
Im sure this is pretty simple but cant figure it out for the life of me...
All I require is either a code or formula that will recognize if there is a '1' in Column AH of 'Sheet1' and if so copy and paste the row containing the '1' into 'Sheet4'. This row can then be deleted from 'Sheet1'.
Thanks for any answers in advance..
Hi Duguid1,
You could give this code a try. It finds out the last cell in Sheet 1, the last cell in Sheet 4, and copies the relevant row (if Cell AH1 contains "1") from Sheet 1 to the last row in Sheet 4
Please Login or Register to view this content.
Hope this helps
Seamus
Filter the data then Cut & Paste
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Can you actually Dim Variables like this? I think that "lastRowSource" didn't get declared. Correct me if I am wrong...Please Login or Register to view this content.
Hi kyrgyzstanart,
You're right enough. It was a typo on my part. Thanks for that
Last edited by SOS; 07-29-2008 at 10:35 AM.
yes, it works now, thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks