Excel 2013 - Recovering old data

[CRUTHERFORD]

Hi,

Brief Overview
In my document, there is a table from A1:D5. I have created two command buttons which use VBA to insert a blank new row or column.

What I'm looking for is another piece of VBA which will revert back to the original table from A1:D5 after either new rows or columns have been added.

Any ideas?

Thanks,
C

 

[pbornemeier]

Create a "table backup" worksheet in that workbook

Add code to your command buttons that adds an empty row under any existing data on the table backup then copies the (thankfully small) table below the blank row with a timestamp in column E prior to inserting the new row or column. this code will run each time a new row or column is inserted.

Add an undo button that will delete the current table and copy the bottom most backup table back to the original location, then erase the data copied from the table backup worksheet.