Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Template' within a worksheet - change existing worksheets
Hello,
I have a workbook that tracks production data for an entire month. In addition to charts and tables, it has 62 nearly identical worksheets that serve as forms for the user to enter data for each shift (2 shifts per 31 days). I am frequently updating the design of these forms, adding new tracking categories and fields. Every month I send the updated blank workbook to the user. Currently every time I change anything on the form, I must go through all 62 sheets to update them. I would like to automate this by having a 'template' sheet that I cna make changes to, then automatically redesign the 62 sheets to that format. The catch is the sheets do have a date/shift field that is different so I can't just copy the sheet as is. Also, I have a summary sheet that is identical in format but sums the data for each field from all shifts. how would I go about doing this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding additional worksheets to an existing template | Excel Discussion (Misc queries) | |||
How do I apply a template to one worksheet in existing workbook? | Excel Discussion (Misc queries) | |||
Update existing excel file on template change | Excel Discussion (Misc queries) | |||
is it possible to apply template to a existing worksheet | Excel Worksheet Functions | |||
apply a template to existing worksheet | Excel Discussion (Misc queries) |