Update Copied Cell

M Morgan

Hello, I have an issue that a report will not rectify.

I have a client facing board, once a cell in each row hits a certain threshold, the row is automatically copied to another board that has different (internal) attributes included. The problem is, there is one cell in each row that needs to continue to update. Right now we are manually linking each cell, but there must be a way to update the entire column one time. As a note, there is a unique identified per row.

Is there any formula I can use?

Thanks!

Paul Newcome

Since you have a unique id, you can use an INDEX/MATCH.

=INDEX({Source Sheet Column To Pull From}, MATCH([Unique ID]@row, {Source Sheet Unique ID Column}, 0))

Paul Newcome

Since you have a unique id, you can use an INDEX/MATCH.

=INDEX({Source Sheet Column To Pull From}, MATCH([Unique ID]@row, {Source Sheet Unique ID Column}, 0))

M Morgan

That worked! Thank you so much!

Paul Newcome

Happy to help.