Updating Multiple worksheets from one "Master List"

Hi,

I'm creating a spreadsheet that contains names in the first column and each worksheet within the excel file displays different information pertaining to those names. Is there a way to link the names column with a master list that can be updated (ie. rows deleted out, inserted in) that will automatically update the other worksheets?

Thanks!

Yes, you can do this with about 3 formulae. Post a sample workbook and I'll set it up for you.

Pete

Great! Here's a sample of what I'm trying to do. I think it's pretty straight forward. Thank you so much!

Test_MasterList.xlsx

Your file isn't what I expected from your description in Post #1. I thought you would have a master list (of everything) and you wanted to be able to split the data out for each employee on different sheets. I'm not clear what it is you want to do with that file - can you elaborate further?

Pete

The "Master List" is the column that will be in each sheet. Each sheet will be keeping track of different information regarding the names in that column. I want to be able to add new names/delete old names in the master list and have all of the other worksheets automatically update with these changes (ie add an entire row or delete an entire row) so that I don't have to manually go into each worksheet and add in the same rows manually.

Sorry for the confusion.

A formula in one sheet can't delete a row in some other sheet(s) if you decide to get rid of someone's name, so you will need a macro to do that.

Sorry, I misunderstood what you wanted.

Pete