Automate resorting in another table

N

nikonshooter

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?
 
S

Shane Devenshire

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?
 
Top