Hi, I have 40 worksheets and I want to change the data in one and apply that
to all other sheets. How can I do this without having to copy & paste on
every sheet
--
Joanne

Hi,

If they are the smae cells in all the sheets: click the first sheet, hold
down the Shift key and click the Last tab. Now make a change to any of the
sheets it is made on all of them. The should not be any sheets selected that
you do not want to get the change. Remember to Ungroup the sheets when you
are finished by right-clicking any sheet.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Joanne" wrote:

Hi, I have 40 worksheets and I want to change the data in one and apply that
to all other sheets. How can I do this without having to copy & paste on
every sheet
--
Joanne

Group the sheets together.

Depending on how many of your sheets you want to do this to:

If *all* sheets: select any sheet, right click the sheet tab, select "Select
all sheets"

If only selected sheets: select one sheet then hold down the shift key and
click the sheet tabs of those you want to include.

What you do to one sheet will be done to all the grouped sheets (almost!).
There are some things that can't be done on grouped sheets like sorting.

Make sure that when you're done you ungroup the sheets! After you're done
right click any grouped sheet tab and select "Ungroup Sheets".

--
Biff
Microsoft Excel MVP


"Joanne" wrote in message
...
Hi, I have 40 worksheets and I want to change the data in one and apply
that
to all other sheets. How can I do this without having to copy & paste on
every sheet
--
Joanne

thats very easy.
I would like to know the type of change you want to make and what are the
values in the sheet

"Joanne" wrote in message
...
Hi, I have 40 worksheets and I want to change the data in one and apply
that
to all other sheets. How can I do this without having to copy & paste on
every sheet
--
Joanne