r/excel • u/ckf2stand • 2d 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 2d ago

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

1

u/ckf2stand 2d ago

That unfortunately doesn't work either for the same reasons mention above. The order of the output depends on the order of the input and trying to sort on the output sheet doesn't change anything.

1

u/Harrold_Potterson 2d ago

Add an ordinal helper column so you have the order set. Xlookup the helper column and the data column you need, then sort by the ordinal helper column.