-
Auto Update Excel Data
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules