How do I? Link Row Headings

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

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
 
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.
 
Back
Top