Forum Discussion
Copying the order of one worksheet to another
Hey Guys, I'm tryinng to copy the order of one worksheet to another and I want to do this according to the order of one collumn. Is this possible and how do I do that if so? Regards, Ricardo
Without seeing your tables its a bit hard to say. Do you have any duplicate data in your original column?
If not you could add a 'helper column' to the second table, then use a match something like
MATCH( table2 value, Table1 column, 0 )
Then order the table by that helper column. It will brake a bit if you have duplicate values though.