making changes to all sheets in a workbook

W

Wayne Cameron

is it possible to make a change on a worksheet and effect the same change on
all the sheets in the workbook?
 
J

Jane

Yes, select all the sheets first, and your changes will take place on all
sheets at the same time.

Jane
 
W

Wayne Cameron

Jane , Thanks for your reply. Unfortunately I didn't correctly state my
problem. I'll try again.
I have 12 workbooks in one folder, one for each month of the year. Within
each workbook, I have 14 sheets. After I had the workbooks and sheets
designed and working correctly I was requested to effect some changes. To
duplicate the changes of the first workbook to the next eleven becomes a
tedious and risky project. I am hoping that there is a relatively easy and
safe way to get the required formula and format changes made to all the
sheets and workbooks at the same time. Could I be that lucky?

Wayne Cameron
 
Top