Hello Leith.
I have uploaded the spreadsheet for your reference. If you click the button on the 'Utilities' tab, you will enter the start date (I have been using the 7th), end date (not changed), and the name of the new sheet. I tried changing the code as you suggested but I get a 'subscript out of range' at line:
If I change it to :
which is a sheet I created just to test this code, 2 things happen. The first is that the header is saved in a new sheet created from the userform input, and the 2nd is that all matching rows are saved in StaticSheet. I am still trying different code combinations with no success. Both the header and the rows matching the date range need to be saved to a new sheet created from the userform.
Not sure what I am missing but hopefully you can work your magic now that you have the spreadsheet.
Thanks,
Andrew
Bookmarks