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

rockraider

New Member
Joined
Jul 21, 2020
Messages
3
Office Version
  1. 365
Platform
  1. MacOS
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!
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
1,031
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
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,.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,169
Members
410,775
Latest member
alal1030
Top