VBA to Copy data on date

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

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.


1 response

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