Copy data from multiple sheets

[accountant.]

I have several excel workbooks, example of one workbook named as (Aug-11) and that workbook contains multiple worksheets , 31 sheets, named as Aug-1 to Aug-31 and one sheet named as (Master). Each worksheet is formated in the same way. Now I want to copy all the data from each sheet on the condition that if Column A contains date then copy that entire row within this column range of A to N and paste it into a single worksheet named as (Master) it should start to paste in this Master sheet from A7.

Column A is of date in each sheet, example: there can be 3 dates in sheet Aug-1 and maybe there can be 5 dates in sheet Aug-2
so in Master sheet, there will be of total 7 dates with entire data starting from A7 to A14 and so on,

[RichardWinter]

This can be done with a small VBA routine: looping through the sheets and copying the relevant rows to the master.
You need to provide a sample workbook where it can be implemented.
To do so push the "Go Advanced" button and click on the paper-clip symbol

[accountant.]

i have attached a sample excel file for this, plz kindly provide me easy vba solution for this. Thanks

[realniceguy5000]

Hi, You can try this:

Please Login or Register  to view this content.

[RichardWinter]

Mike's solution works perfectly.
Just for the fun of it I pasted into your workbook module, run CopyToMaster - Bingo.

You should mark your thread solved.
Thanks
Richard