Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I make changes tonumersous duplicate worksheets witout havi
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 |
#2
|
|||
|
|||
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. "mlofton" wrote: 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 |
#3
|
|||
|
|||
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 "Mike" wrote: 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. "mlofton" wrote: 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 |
#4
|
|||
|
|||
Make changes to one file then close it.
Open up windows explorer, highlight the file, hit control c then hit control v four times... "mlofton" wrote: 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 |
#5
|
|||
|
|||
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 On Tue, 6 Sep 2005 17:11:35 -0700, "mlofton" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make duplicate entries blank | New Users to Excel | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
What formula should I use to compare duplicate data between worksh | Excel Worksheet Functions | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions |