Capture only rows where a specific cell is populated.

--------------------------------------------------------------------------------

I have a workbook with 31 sheets named by date (5-1-11, 5-2-11, etc). These sheets contain data in rows 4-25.There is another sheet in the workbook named”Recap”. I would like to have only the data (Values only, no formulas) from rows 4-25 of the daily sheets imported into the Recap sheet if the cell of the rows in column B is populated.It should be pasted into A4 of the Recap sheet.
It would be nice if there was a blank row separating data of different Daily sheets.
I hope this sounds logical, if not I’ll take another try at it.
Thanks.

cure4glass1,

See attached for how the following macro works:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Tiger, That worked like a charm! Thanks so much,really appreciate that!

Tiger,
The worksheet with the code you provided works great. However I would like to add a sheet"Code List" that will not be part of the Loop.Can you( or anyone) point me in the right direction? Thanks again !

Stumbled upon a solution,Thanks!!