VBA to Copy data on date

Closed
technogene007
Posts
2
Registration date
Thursday May 27, 2010
Status
Member
Last seen
August 30, 2012
- Aug 30, 2012 at 12:40 AM
 technogene007 - Sep 14, 2012 at 12:48 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Sep 11, 2012 at 07:00 AM
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
0
technogene007
Sep 14, 2012 at 12:48 PM
Ok Sure i ll do it.....:)
0