There is a well-known option called "fill down formulas in columns adjacent to data" but I want to "fill down VALUES in columns adjacent to data". Do you have any ideas on how to accomplish this?
I have an External Data linked table that pulls information from a SQL Server. I want to be able to put some notes in the right column adjacent to linked data. As rows are being added or removed from the linked data, my notes are getting out of sync with the original row number. Is there a way of tricking Excel in keeping those columns synced?

Can SharePoint do this maybe?