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

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

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