Copy row & cell link

Sidonia Posteuca

Is it possible to link cell changes, attachment updates, and comment updates when a row is automatically copied to another sheet?

The idea is that once the row is copied to another sheet, any changes that are made to the initial sheet (date changes, new attachments and comments) are replicated in the new sheet.

This would be a one-way street. But the biggest issue is that as of now, when the automation runs, the row is copied when a check box is checked and whatever exists in that row is copied over. But when changes are made to the initial sheet, it does not carry over or replicate into the new sheet.

James Keuning

I always hate to say no, because maybe there is a way.

I suggest using INDEX and MATCH to look back to the source data to bring in relevant fields from the original source.