| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making changes to all sheets in a workbook
is it possible to make a change on a worksheet and effect the same change on
all the sheets in the workbook? -- D. W. Cameron |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making changes to all sheets in a workbook
Yes, select all the sheets first, and your changes will take place on all
sheets at the same time. Jane "Wayne Cameron" wrote: is it possible to make a change on a worksheet and effect the same change on all the sheets in the workbook? -- D. W. Cameron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making changes to all sheets in a workbook
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 -- D. W. Cameron "Jane" wrote: Yes, select all the sheets first, and your changes will take place on all sheets at the same time. Jane "Wayne Cameron" wrote: is it possible to make a change on a worksheet and effect the same change on all the sheets in the workbook? -- D. W. Cameron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to link several sheets in single workbook for searching purposes. | Excel Discussion (Misc queries) | |||
| Finding specific sheets within a workbook | Excel Discussion (Misc queries) | |||
| In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
| How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions | |||
| How do I convert an Excel workbook that has mulitple sheets into . | Excel Worksheet Functions | |||
Hybrid Mode
