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.
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.