I am trying to add another name to appear on a table (which is set up with
formulas) on every worksheet in an excel document.

I am using Microsoft Office Excel 2003.

Hi Summer

not really sure what you're after, but hopefully the following will help
... click on one of the other names on the first sheet and have a look in
the formula bar - i'm guessing it says a name, e.g. "Joe Bloggs",
now click on Joe Bloggs on the second sheet and have a look at the formula
bar - does it say "Joe Bloggs" or does it say Sheet1!A10 or something
similar? .. check each sheet

if they all have the name, then you can group the sheets - click on the
first sheet you want to include in the group, hold down your shift key and
then click on the last sheet in the group ... all the sheet tabs should go
white ... now go to the cell where you want the name entered and type it,
now right mouse on a sheet tab and choose UNGROUP sheets ... all the sheets
should have the name entered. NOTE: this method should only be used if the
structure of each of the sheets is identical, as it will over-write any
information in the cells on each on the sheets.

if they have formulas to bring the name across, you'll need copy the
formulas on each sheet (can use the group method for this) and then when you
type the name in the first sheet it should appear on the others.

Please let us know how you get on

Cheers
JulieD



"Summer" wrote in message
...
I am trying to add another name to appear on a table (which is set up with
formulas) on every worksheet in an excel document.

I am using Microsoft Office Excel 2003.

Hi Julie,

You're a star!!

Thank you so much. Your explanation was great - clear and easy to follow!!

Kind regards,
Summer




"JulieD" wrote:

Hi Summer

not really sure what you're after, but hopefully the following will help
... click on one of the other names on the first sheet and have a look in
the formula bar - i'm guessing it says a name, e.g. "Joe Bloggs",
now click on Joe Bloggs on the second sheet and have a look at the formula
bar - does it say "Joe Bloggs" or does it say Sheet1!A10 or something
similar? .. check each sheet

if they all have the name, then you can group the sheets - click on the
first sheet you want to include in the group, hold down your shift key and
then click on the last sheet in the group ... all the sheet tabs should go
white ... now go to the cell where you want the name entered and type it,
now right mouse on a sheet tab and choose UNGROUP sheets ... all the sheets
should have the name entered. NOTE: this method should only be used if the
structure of each of the sheets is identical, as it will over-write any
information in the cells on each on the sheets.

if they have formulas to bring the name across, you'll need copy the
formulas on each sheet (can use the group method for this) and then when you
type the name in the first sheet it should appear on the others.

Please let us know how you get on

Cheers
JulieD



"Summer" wrote in message
...
I am trying to add another name to appear on a table (which is set up with
formulas) on every worksheet in an excel document.

I am using Microsoft Office Excel 2003.

Hi Summer

you're welcome - glad it's solved

Cheers
JulieD

"Summer" wrote in message
...
Hi Julie,

You're a star!!

Thank you so much. Your explanation was great - clear and easy to
follow!!

Kind regards,
Summer




"JulieD" wrote:

Hi Summer

not really sure what you're after, but hopefully the following will help
... click on one of the other names on the first sheet and have a look
in
the formula bar - i'm guessing it says a name, e.g. "Joe Bloggs",
now click on Joe Bloggs on the second sheet and have a look at the
formula
bar - does it say "Joe Bloggs" or does it say Sheet1!A10 or something
similar? .. check each sheet

if they all have the name, then you can group the sheets - click on the
first sheet you want to include in the group, hold down your shift key
and
then click on the last sheet in the group ... all the sheet tabs should
go
white ... now go to the cell where you want the name entered and type it,
now right mouse on a sheet tab and choose UNGROUP sheets ... all the
sheets
should have the name entered. NOTE: this method should only be used if
the
structure of each of the sheets is identical, as it will over-write any
information in the cells on each on the sheets.

if they have formulas to bring the name across, you'll need copy the
formulas on each sheet (can use the group method for this) and then when
you
type the name in the first sheet it should appear on the others.

Please let us know how you get on

Cheers
JulieD



"Summer" wrote in message
...
I am trying to add another name to appear on a table (which is set up
with
formulas) on every worksheet in an excel document.

I am using Microsoft Office Excel 2003.