multiple workbooks with common structure

  • Thread starter Thread starter giacomo
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
summarizing data from various workbooks 3
Undo jumps between multiple open workbooks 4
Drop down Lists from a different workbook 1
Editing Data in Multiple Worksheets/Workbooks 1
Locking Down Workbooks Properly & Disabling Functionality 2
Copy formulas to another workbook 4
Shared Workbook Protection 1

Back
Top