Macro for copying data from multiple woorkboks in to single wrkb

Closed
narun226
Posts
1
Registration date
Monday January 19, 2015
Status
Member
Last seen
January 19, 2015
- Jan 19, 2015 at 10:33 AM
Hi All,

I need to copy data from 20 workbooks and save in the single workbook, by using condition like, " Date " so if run the macro all the workbooks which contains this date should copy all the rows and save it in the single Macro.

For Example

wrkb 1
s.no date status
1 19-Jan-2015 Completed
wrkb-2
s.no date status
1 19-Jan-2015 Completed
2 20-Jan-2015 Completed

date : 19-Jan-2015 data i need

Final Output:

s.no date status
1 19-Jan-2015 Completed
2 19-Jan-2015 Completed

see, in the wrkb-2 we have two rows but copied on data of 19-Jan-2015

Thanks & Regards,
Arun