Sort Multiple Tables at the same time

[nilelator]

i have 3 tables that are in the same workbook but different sheets. Table 1 "Base bid RECAP_AREA_SYSTEM", Table 2 "VE RECAP_AREA_SYSTEM", Table 3 "Diff". The tables all have the same headers names, same amount of Col "18" and Rows "128", right now i can sort each table one at a time which is time consuming since i need to be able to sort different ways

question is there a way to sort all three tables at the same time

thank you

Nilelator

[shg]

Not unless you can merge them into a single table and sort them all together.

You could record a macro to sort them sequentially.

[nilelator]

not sure if i could put them in the same table because i am after the difference of 6 different columns but when i sort the formulas will not work. don't sort all three the same way. this is the formula that i am using in the 6 columns. "=Table1[@Material]-Table13[@Material" there are only 3 tables not sure way it is saying 13.

[shg]

That leaves option 2.

[nilelator]

i am combining the tables, little more work but it puts all the info in one table.
thank you for your help.

[shg]

You're welcome.