using named cells across worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've named various cells after producing a multi-worksheet model. The named
cells can be applied in the worksheet they are in but I can't see how to
apply them across other worksheets. At the moment, the only option I can
think of is manually updating every formula in all the connected worksheets!
Any ideas.

Nick
 
You defined the names so that the names included the worksheet name, too?

Sheet1!test
sheet2!test
....
Sheetx!test

Then you can just use them by making sure you include the complete name:

=sum(sheet1!test,sheet2!test,sheetn!test)

Is that what you meant???
 
By 'worksheets' did you mean sheets within a single workbook, or did you
mean 'workbooks,' i.e., separate files?

If you actually meant sheets within a single workbook, Dave's answer is the
way to go. If you mean interconnected workbooks, you'll have to qualify the
reference to the named range with the name of the workbook file and the
sheet name. To see the actual format for the reference:

1) open the workbook where you want to reference the named range
2) navigate to the cell that will contain the link
3) type an equals sign
4) press Ctrl-F6 until you've activated the workbook with the named range
5) press the F3 key to list the named ranges and select the one of interest
and click on OK
6) press the Enter key

Your cell will now have the exact format you need to use to link to the
named range


Duke
 
Back
Top