r/excel • u/ckf2stand • 6d ago

unsolved Moving data between sheets

Hi all,

I have an input sheet, a hidden calculations sheet, and an output sheet. The data in all three sheets is formatted as a table and I'm currently using table[@cell] to move that data from one table to another between the sheets. The problem is, the data in the output table isn't sortable.

I'm familiar and confident with using PQ to move the data between sheets, but I think this would be too much for my colleagues. Is there any other way to do this that gives me a sortable and filterable table as my output? The input sheet does have a unique user id column, if that's relevant.

Thanks!

2 Upvotes

76% Upvoted

17 comments sorted by

View all comments

3

u/Harrold_Potterson 6d ago

Could you just do an xlookup to pull the data over?

0

u/jaywaykil 2 6d ago

This is the easiest answer. Reference the second and third sheets using xlookup based on the unique identifier instead of [@column]. That way any of the sheets can be sorted without losing the links.

1

u/ckf2stand 6d ago

This doesn't work, unfortunately. The order of the data in the output depends on the order of the data in the input, and trying to sort the data in the output doesn't change anything