VBA to Copy data on date

[Closed]
Report
Posts
2
Registration date
Thursday May 27, 2010
Status
Member
Last seen
August 30, 2012
-
 technogene007 -
Hello,

Team please help me with the below situation.

I have 15 workbooks, every day i capture data in sheet1, it has 8 columns, with date in 7th column which i update as work date the day i work.

i tried recording macro but data is overlapping. i would like a msg box popups while running the code that asks for date, or date range. once i feed required dates for which i want data , the code copies all the columns and rows from all the workbooks with that date or date range and paste in new work book. Date format is mm/dd/yyyy.

Any help will be much appreciated.

Regards,
technogene007

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you post a sample book on some public file share site and post back here the link to the file here. In the file if you could have some sample raw data and a finish product as you would like to see

Ok Sure i ll do it.....:)