Sort data on multiple worksheets on change

Excel Excel 2007
November 22, 2010 at 21:54:07
Specs: Windows Vista
I have an Excel 2007 spreadsheet that tracks various pieces of data on our personnel. I have the data categorized on individual tabs. Presently, if I need to add or delete someone from the chart, I have to perform the same action on 6 or 7 tabs. I would like to create someway to add a name to a master roster that would populate all the tabs and sort them alphabetically... but the associated data on all tabs must sort to the correct person. I'd like to do it in VB... any ideas? (sorry, using a database isn't a viable option)

See More: Sort data on multiple worksheets on change

Report •

#1
November 23, 2010 at 07:02:44
Before we could offer any assitance, we would need to know more about your workbook. You said that you have "the data categorized on individual tabs".

Then you said you want to "to add a name to a master roster that would populate all the tabs" .

Copying data from the Master Roster upon entry is doable, as is sorting each individual sheet, but we would need to know exactly what you want copied and to where. I doubt it's as simple copying the entire line since that would mean that all of your sheets would look the same.

So you need to tell us what gets copied to each sheet and where it gets copied too.

You also need to tell us how you want the macro triggered. Do you want click a button after the data is entered, do you want it to happen automatically as soon as a certain column or row is changed, etc.?

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question