SOLVED

Link table row permanently to another worksheet

Contributor

Hi,

I am trying to link a row in a table to another worksheet.

When I reorder the list (worksheet 1) the linked row values (in the 2nd worksheet) should stay the same (and should not change position).

3 Replies
best response confirmed by Change99 (Contributor)
Solution

@Change99 

That's to have some unique ID for the data and get data using VLOOKUP, INDEX/MATCH or XLOOKUP

Thank you! The linked row should not be a formula as it will be used in a pivot table. Are any of the options viable with this new criteria?

@Change99 

That doesn't matter, PivotTable takes cell values returned by formulas or entered manually.