Adding / deleting cells to worksheets from a seperate worksheet

[G. Dagger]

Hi- my question sounds like a link type subject, but i need to do more than
that, specifically, I wish to have a list of names that I can add to or
delete from, and have these changes be directly / automatically reflected in
one or more worksheets (in the same workbook) such that rows are
automatically inserted / deleted depending on the sitation. As well, I have
multiple entries of these names per worksheet, such that I need the changes
to be reflected many times from the single core name list.

Hope someone can help me soon! Thanks a lot.

 

[Bernie Deitrick]

G.,

The standard reply to this sort of question is: Don't do that! It is a bad idea, and a case of data
corruption just waiting to happen. Much better is to add columns to one sheet, and enter a category
into those columns that would allow you to filter the database to show what the individual sheets
would have shown. You can also set up views to hide columns, etc.

HTH,
Bernie
MS Excel MVP

 

[G. Dagger]

Thankyou for your prompt help Bernie, I shall just do the extra steps to
avoid any issues down the road. Gary.