Associating data of two columns

johnbysea

New Member
Joined
Jun 27, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,
I have a large spreadsheet with data cells for each item on indivual rows (over 3000 rows). The identifier for the item (its name) is a random generated (not within Excel) code of letters and numbers. For each item there will be a cell with text which are notes on that item. This spreadsheet is modified by another user who adds more items by adding more rows within the spreadsheet at multiple places. This other user also deletes the notes column for all cells. I would like to add back the notes from the previous spreadsheet version to the new version but have the problem that new rows have been added. Is there a method to associate the notes of an item to its identifier so that they can paste correctly into the new, modified spreadsheet?

Thanks to all contributors.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,745
It would be easier to help if we could see what your data looks like. Use the XL2BB add-in (icon in the menu) to attach screen shots of both the old and new sheets. Explain in detail what you want to do, referring to specific cells, rows, columns and sheets using a few examples from your data.
 

Watch MrExcel Video

Forum statistics

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