| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
linking Worksheets
could someone tell me if this is possible, if so how to go about it.
worksheet (named 'master' ) in a workbook, (named 'blank weekly overtime') everyweek this workbook will be copied and renamed to 'weekly overtime+weekdate' if any data is changed on the master sheet, the 'blank weekly overtime' workbook will be changed to match it. this would of course ensure all future copies are kept updated. I do not wish to have this master sheet kept in a workbook of its own and have all other workbooks linking to it, because this would mean all previous copies would also be changed. hope that makes sense, and thanks for your time, Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
linking Worksheets
Hi Steven
Check out the Excel help for Templates -- Regards Ron de Bruin http://www.rondebruin.nl "Steven" wrote in message ... could someone tell me if this is possible, if so how to go about it. worksheet (named 'master' ) in a workbook, (named 'blank weekly overtime') everyweek this workbook will be copied and renamed to 'weekly overtime+weekdate' if any data is changed on the master sheet, the 'blank weekly overtime' workbook will be changed to match it. this would of course ensure all future copies are kept updated. I do not wish to have this master sheet kept in a workbook of its own and have all other workbooks linking to it, because this would mean all previous copies would also be changed. hope that makes sense, and thanks for your time, Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
linking Worksheets
Steven email me, I have the template for what you need (I wrote it for a
client who never paid so someone may as well use it). Cheers, Dean "Steven" wrote in message ... could someone tell me if this is possible, if so how to go about it. worksheet (named 'master' ) in a workbook, (named 'blank weekly overtime') everyweek this workbook will be copied and renamed to 'weekly overtime+weekdate' if any data is changed on the master sheet, the 'blank weekly overtime' workbook will be changed to match it. this would of course ensure all future copies are kept updated. I do not wish to have this master sheet kept in a workbook of its own and have all other workbooks linking to it, because this would mean all previous copies would also be changed. hope that makes sense, and thanks for your time, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking two worksheets | Excel Worksheet Functions | |||
| Linking worksheets | Excel Worksheet Functions | |||
| Linking Worksheets | Excel Worksheet Functions | |||
| I am getting #VALUE! when linking worksheets - what am i doing wro | Excel Discussion (Misc queries) | |||
| Need Help linking worksheets | New Users to Excel | |||
Linear Mode
