How do I make changes tonumersous duplicate worksheets witout havi

[Guest]

How do I make changes to numersous duplicate worksheets witout having to
change each one indivdually. I have 5 of the same worksheets and need to
make changes periodically. I would like to have 1 master and the rest
copies. Thanks

 

[Guest]

Select an empty cell, hit = then click on another worksheet and click on a
price cell then hit return....our your wheels starting to spin?....create a
separate worksheet just for prices as a template? If you are doing one
worksheet per week you will want to archive old worksheets away. You will
reach a limit.

 

[Guest]

Thanks again.....Thats what I figured I was going to have to do... As I am
copying down it tells me that "This operation requires the merged cells to be
identically sized" there seems to be a spacing difference between some of
the worksheet,,,,but I don't want to delete Inv. wk 2, Inv wk. 3 etc. because
there are other worksheets in the workbook that are already linked to those
particular worksheets and I am trying not to have to redo to whole thing and
start over,,,many many hours?????... This particular workbook has about 10
worksheets in it... Thanks for all the help once again

 

[Guest]

The worksheets are allready in the same workbook, I have an Inventory that I
take every week, and instead of having to make changes to every worksheet (
price change, item change etc.) I would like to be able to make 1 change and
have the rest be duplicated. Whether it be inserted cells or rows.. Thanks
again for your help....

 

[Guest]

Make changes to one file then close it.
Open up windows explorer, highlight the file, hit control c then hit control
v four times...

 

[Gord Dibben]

You can "group" the sheets by right-clicking on one and "Select all sheets" or
by using CTRL + Click for non-contiguous sheets or SHIFT + Click for
contiguous sheets.

What you do to one will be done to all in the "group".

IMPORTANT WARNING.........do not forget to right-click and "ungroup" when work
is complete.


Gord Dibben Excel MVP