Worksheets Inheriting Contents

[joe_idzhar]

Hi All,

I'm currently working on creating a set of specifications using Excel
These specifications are contained within a single Excel spreadshee
which contain multiple worksheets, each relating to a different aspec
of the form (say calculations, form rules, dependencies). The proble
is that anytime you make a change to one form, say you change text, o
add another column, you must make the corresponding changes in all th
other tabs. This can be very time consuming - especially if there are
tabs.

My question is this: Is it possible to create a parent 'Look and Feel
worksheet and have all other worksheets inherit from it while als
retaining their own data? For example, if the parent worksheet contain
a 5x10 grid, with text, is it possible to force the other worksheets t
inherit this. And also, if you make changes to the parent workshee
will all other worksheets inherit these changes and incorporate the
into their own data?

Any suggestions at all will be most appreciated.

Thanks

 

[Dave Peterson]

Not really.

But if you're the only one changing the design of the workbook, you can select
the worksheets (click on the first tab and ctrl-click on others) and all the
worksheets in that group will get the same same change.

Remember to ungroup the worksheets (rightclick on any grouped worksheet tab and
choose Ungroup Sheets).

 

[joe_idzhar]

Thanks for that Dave!