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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
if statement with vlookup 1
Using Excel VBA: sending output data table to created .csv file +append Options 1
VBA - retrieve data on last create named range from previous inserted named range 0
How to unlink TOC from a doc 0
need a macro to append data to a table 3
How to export table from outlook into ms access table? 0
Sum value in all columns that their title is the same 1

Top