Hi everyone!

I don't have much experience with excel beyond the basics, so I'm not even sure that what I want is possible.

I have an excel file with 3 columns (Job No., Name, Year), and I have 3 worksheets in the file. The first is a master list sorted by Job Number, the second needs to be sorted by name, and the third sorted by name then year (at least I can sort .

Is it possible to set it up so that when a new job is added to the master list, it automatically populates into the other 2 worksheets and then resorts itself?

Thanks for any suggestions!