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