My workbook TAB 1 has 14 data fields (columns A thru O). There are 40 rows, each has the identical 14 data fields.
When the user closes / saves the workbook, the data should be duplicated (written or saved) onto TAB 2. It needs to be saved on TAB 2 incrementally, the top row on TAB 2 will always represent the most recent data entered on TAB 1, all other data will incrementally drop down one row. An option would be to save the data as a .csv file in the same drive/directory as the workbook.
A friend suggested using a pivot table and another indicated it might be done utilizing VBA code. I'm lost with both suggestions. Can anyone assist ?
Example workbook attached.
Thank you.
Bookmarks