Copy formulas, format, validation to sheet with values

U

usww

Environment: Excel 2000, Win 2000

I have a workbook with 12 sheets, one for every month of a year, all
the same size, same format, just different values.
I am still making changes to the workbook application, e.g. formulas,
formats, validation, conditional formatting.
So I change the sheet for one month, and then have to get the changes
duplicated for all the other 11 sheets in the workbook.
What is the best way to do that, especially for the formulas?
Paste Special with deleting the constants afterwards is not a solution
here, as some of the target sheets already have values entered manually
that must not be lost.

Are the solutions different depending on whether the worksheet change
included inserting/deleting columns/rows or not?

Thank you,
Werner
 
R

RagDyer

Have you tried "Grouping" all your WSs together?
That way, *whatever* you do to one, will be duplicated to *all* the others
included within the "group".

Click on the first sheet tab, hold <Shift>, and click on the last tab.
All the tabs should now be white, with the tab in focus (actual sheet being
worked on) being displayed in Bold.

Don't forget to "Ungroup" after you've completed your changes by right
clicking in any grouped tab and choosing "UngroupSheets".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Environment: Excel 2000, Win 2000

I have a workbook with 12 sheets, one for every month of a year, all
the same size, same format, just different values.
I am still making changes to the workbook application, e.g. formulas,
formats, validation, conditional formatting.
So I change the sheet for one month, and then have to get the changes
duplicated for all the other 11 sheets in the workbook.
What is the best way to do that, especially for the formulas?
Paste Special with deleting the constants afterwards is not a solution
here, as some of the target sheets already have values entered manually
that must not be lost.

Are the solutions different depending on whether the worksheet change
included inserting/deleting columns/rows or not?

Thank you,
Werner
 
D

Dave Peterson

If you group your sheets (click on the first worksheet tab, then
ctrl-click/shift-click on subsequent), then any change you make on one will be
reflected on the others.

But watch out. Make sure your formulas go in the exact same location and
remember not to change unique text.

It might be better to delete 11 of the sheets and then fix one perfectly. Then
copy that one 11 times.

....just depends...

And remember to ungroup the sheets when you're done--else you'll be really mad!

And excel tries to help you by putting [group] in the title bar when you have
sheets grouped.
 
U

usww

Thank you for your replies, they were really helpful.
Grouping the worksheets is a good solution for my question.

Werner :
 
Top