Forum Discussion
Excel sorting
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?
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?
Andrew,
this is not possible without a helper table.
However Matt Allington posted a workaround. But it is not easy to set up.
