Excel sorting

[Andrew Atack]

Hello

I am linking multiple sheets on excel.

If I pull data through to sheet 2 from sheet one. Then add other columns in sheet 2. But then add data in sheet 1 and sort the column. I would like the additional data in sheet 2 to move along with the formulated cell that was updated in sheet 1. Rather than sort the the name column to sort, but the additional data stay where it is unsorted.

Hope this makes sense

Any ideas?

[#2]

Andrew,

this is not possible without a helper table.

However Matt Allington posted a workaround. But it is not easy to set up.

Self Referencing Tables in Power Query