VLV98
06-02-2021, 07:15 AM
Hello,
I have an Excel file with one "Master" tab and 6 "client" tabs. I have a code that copies the last row of the active worksheet into Master tab, but only certain cells from the row.
Now once the cells are copied into Master I would like to be able to keep it updated, so if I make a change into one of the cells (in any client tab) copied from Client to Master then the change is reflected into the "Master".
Is this possible?
I have a code that track all the changes made in Master with date, old data, new data, who made the change, time and link to the cell so that's a safe. but so far I can only do manual changes.
Any advice would be greatly appreciated.
Thank you,
VLV
I have an Excel file with one "Master" tab and 6 "client" tabs. I have a code that copies the last row of the active worksheet into Master tab, but only certain cells from the row.
Now once the cells are copied into Master I would like to be able to keep it updated, so if I make a change into one of the cells (in any client tab) copied from Client to Master then the change is reflected into the "Master".
Is this possible?
I have a code that track all the changes made in Master with date, old data, new data, who made the change, time and link to the cell so that's a safe. but so far I can only do manual changes.
Any advice would be greatly appreciated.
Thank you,
VLV