Making sure that fixed values stay in the right row with dynamic data

[rockraider]

Hi,

I am using Index & Match to populate a spreadsheet with data from another spreadsheet. Right of each row with the dynamically generated values I would like to add several columns with notes. How can I make sure that these notes stay in the right row when new data is added to the source spreadsheet and the order of the dynamically generated row changes?

Thank you in advance!

 

[jmacleary]

Hi rockraider and welcome. I have had a similar problem - my solution (or hack or work-around) was to have a separate tab with the columns of notes, indexed by whatever makes your original data unique. Then rather than the notes being on each line, use vlookup to get the notes from your base tab. If you are updating notes on the original sheet, create an on change macro to copy the notes from your dynamic sheet to the correcdt row on your fixed sheet,.