Since you rocked out my first request so fast, I figured I'd follow up with another simple one.... and the topic says it all.
Worksheet 1 is populated with tons of data. If Cell in column B is NOT empty, copy that row to Worksheet 6.
So the way I see it, on worksheet six, in A1 I would say (in excel terms) if worksheet 1, Row 1, Column B is NOT empty, copy worksheet 1, row 1 right here.
can you translate that for me?
Thanks :o)
Hi,
Use a data filter on sheet 1 and filter on column B for non blanks. Then simply copy all the visible rows and paste them to sheet 6. If you need to keep repeating this exercise then simply create a macro to do it.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Or a macro.
In a standard module.
Please Login or Register to view this content.
Last edited by HSV; 03-31-2011 at 05:56 PM. Reason: sheetname translate
Harry.
Here is autofilter macro. You will have to update the sheet names to match yours are top of macro.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks