I'm trying to clean-up a huge bulk of data.
What I want to do is automatically select all rows, where column K contains text value "Closedloss", and have all these rows cut/pasted to Worksheet "ClosedCases".
The second is similar to the first, but I want to select all rows where column J contains a value of 60-80, and have all these rows cut/pasted to Worksheet "MidRange".
Many thanks!
Last edited by Boraxx; 10-03-2009 at 06:24 AM. Reason: Closed
Hello Boraxx,
This macro will copy the rows if the cells in column "J" or "K" meet the criteria. The empty rows are deleted and the rows shifted up. The copy data starts in cell "A1" on the sheet "MidRange".
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Works like a charm!!!
Many many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks