Please assist, I have a VBA Marco I'm trying to write that would copy data from one or several worksheets onto a separate sheet within the same workbook based on date information stored in column A of these sheet(s).
The workbook contains several worksheets with the first column of these containing the date for each record. I wish to have excel return all rows that contain data that falls within the date range selected and place the information on the "Statement Template" sheet starting in row A21.
Perhaps a popup box to enter the date parameters with a dropdown selection for each sheet to choose or an "ALL"option to retrieve information from all sheets.
I have attached a copy of the spreadsheet with three of the sheets containing data and the Statement Template sheet.
Bookmarks