Copying the order of one worksheet to another

[Ricardo Petri]

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

[#2]

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.