N nikonshooter Jan 7, 2009 #1 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?
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 Jan 7, 2009 #2 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?
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?
