How do I? Link Row Headings

[Tiffany]

I have 14 separate spreadhseets .. to log data.. they have
the same headings and a second tab with information that
is the same for each.
I want to link the headings and the second worksheet (tab)
to a "template" spreadsheet so that when changes are made
to the template.. all 14 spreadsheets are updated.

What is the easiest way to do this??

Thanks so much!
Tiffany

 

[Dave Peterson]

These are all in the same workbook???

If yes,
create a worksheet named template (or whatever you want).

Select all the sheets that you want to have the formula
(click on the first and ctrl-click on the subsequent)
(notice that excel placed [group] in the title bar)

Then use a formula like this:
=if('template'!a1="","",'template'!a1)

and drag to the right.

select one of the grouped sheets and right click on the tab and select ungroup
sheets--or you'll be changing all those sheets with each update.