Hi,
I have a little problem with some coding that I am working on.
I need some code I can assign to a button that, once clicked will prompt the user for a date range (dd/mm/yyyy to dd/mm/yyyy).
The code will then use this date range to search through upwards of 200 worksheets for any matches.
If found, it will copy certain data from those sheets, to a weekly summary sheet.
I have the code that gets the date range in the form of variables, but I don't know enough to write the code that will search the sheets and copy the required data.
Here is an example spreadsheet.
Any help on this would be greatly appreciated.
Ed
date range look up and copy.xlsx
Bookmarks