I want to update an excel sheet automatically which is edited manually.
I have 2 excel files:
One is a master file that has 3 sheet
The second is a tracking file that also has 3 sheet
So, whenever the master sheet will be edited by someone else who performs operations like added some rows, columns, or deleted something then I want to update the tracking sheet as per the master sheet.
I don’t want to do any editing on the tracking sheet.
How can we do this?