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