Copy updated cell values of one sheet to another
I have two sheets with exact same columns.
When any cell(s) value of row in sheet 1 is updated, then I want to update same row with unique identifier ID if existing in sheet 2 to be updated with new cell values as well.
Please help how it can be accomplished.
Let say Price Per unit of Row 3 is changed in first sheet, then same cell in sheet 2 should be updated.
Problems I am facing:
When row is updated
Then Identify cells that were changed in source sheet
And update changed cell values in destination sheet
Help Article Resources
Check out the Formula Handbook template!