i have 2 sheets with name X and Y. i want to syncronize both the sheet where it will have a same unique task number on column A and if both sheet has the same unique task number it should sync the row of that cell from column B. if any change is made in sheet X it should show on sheet Y and if any change made in sheet Y it should show in sheet X. Example – if i have a unique number on sheet X at A1 as 2 and i have same unique number 2 on sheet Y at A3 so the whole row 1 in X and row 3 in Y should sync. And this should not make change in Column A of any of the sheets. Also to make sure the latest change should be synced
Neeraj Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.