Dynamically changing Info from one sheet to another

  • Thread starter Thread starter noobie6675
  • Start date Start date
N

noobie6675

Hi all,

Im not sure if this can be done (pretty new to all this) but what i
would like to do is:

have one excel document with 26 sheets, each of the 26 sheets will
contain a list of approx 1000 names. When a sheet gets updated (a name
is deleted or added) i would like it to dynamically change all sheets
larger than it.

For example if i delete a name of sheet # 9, i would like sheets 10
onwards to to contain that name either but sheets 8 and below must
remain unchanged.

anyone have an idea how i could tacke this problem?

thanks
 
Hi,

Without having seen your data structure I would advise you
to reconsider your design.

In Excel many things are easier when you use a single
sheet with all information below each other, like a
database table.

That way, there is only one place to update data.

There is a huge number of tools and functions that can
help you present and summarise the data in such a table,
making the use of many sheets superfluous.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Hmmm....the only way I could think of was to GROUP the
sheets that you want to change, and the change will roll
through all sheets.
Anyone have another idea?
Good Luck!
 
You can do this by GROUPING all the sheets that will
require the change. The change will then flow through
each of the sheets in the group.
Good Luck!
 
Back
Top