multiple workbooks with common structure

G

giacomo

I'm working with one basic workbook which I feed with
different data sets thus generating many workbooks of the
same basic type (but containing different data). Whenever
I think of an improvement I find myself in the tedious
and dangerous (in terms of increased potential for
errors) position of implementing the change to
each 'basic' clone. Is it possible to have certain
areas/worksheets of a workbook linked so that changing
one changes all the other 'similar' workbooks? However I
want other areas of the workbook to be unlinked to other
workbooks of the same type.
Sorry about the convoluted explanation. I hope somebody
understands me.
Regards,
giacomo
 
U

unlikeKansas

This may help

You can select multiple sheets within the same workbook by holding down the cntrl key and clicking any sheet tab that you want. You can select all sheets by clicking the tab for the first sheet, holding down the shift key and clicking the tab for the last shee

When you enter values or formats or formulas, etc in any cell or range in the currently viewed sheet those changes are replicated in any other sheets you have selected. This also works for deleting columns, rows, etc

If all your sheets are similar (ie the data is different, but the stucture is consistent) this method will replicate the change across all selected sheets within the workbook

----- giacomo wrote: ----

I'm working with one basic workbook which I feed with
different data sets thus generating many workbooks of the
same basic type (but containing different data). Whenever
I think of an improvement I find myself in the tedious
and dangerous (in terms of increased potential for
errors) position of implementing the change to
each 'basic' clone. Is it possible to have certain
areas/worksheets of a workbook linked so that changing
one changes all the other 'similar' workbooks? However I
want other areas of the workbook to be unlinked to other
workbooks of the same type
Sorry about the convoluted explanation. I hope somebody
understands me
Regards
giacom
 
Top