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
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