I have a spreadsheet, and I am trying to come up with a way to essentially archive and clear data from a table.
In the attached spreadsheet, there is a macro, and so far is moves and clears data from cells D3:D6 and H4:H6 from the CurrentReceipts worksheet to the Archives workbook.
Below that header data, there is a table, which will always have at least one, but potentially many entries. I need to find a way to move that data to a new line in the Archives worksheet, drawing on the same source data in the header row each time the macro is activated. In other words, if there are three separate entries in the table on the CurrentReceipts worksheet, the same header data from D3:D6 and H4:H6 would be moved into three separate rows in the Archives worksheet, then the data from B10:H10 would be moved into each respective column in the Archives worksheet from columns I:O. Then, I need to clear the table, deleting all rows but one blank row (and the total row, of course). Hopefully that makes sense.
Any help is much appreciated!
Bookmarks