Hi,

You can either add a Worksheet_Change event or you can set up fancy
formulas, which may or may not work depending on what your data is.

Is new data, new rows of data being added to or deleted from table 1?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"nikonshooter" wrote in message
...
I copied table 1 data to table 2 and resorted it. As I update table 1
data,
how can I automate the sorting in table 2?