Hi Bob,
Thanks for responding, much appreciated.
Your solution is definitely an option.
I wanted ...
1. common NAME definitions across spreadsheets (i.e. the same "Total"
name definition in different spreadsheets)
AND
2. common formulas across spreadsheets (i.e. A1=Total + Subtotal)
but it looks like I only get the choice between 1 or 2, not both.
You are saying use
A1 (cell in spreadsheet 2001) = 'Year 2001'!Total + 'Year
2001'!Subtotal
and
A1 (cell in spreadsheet 2002) = 'Year 2002'!Total + 'Year
2002'!Subtotal
so unique formulas, same NAME definitions...
Correct?
Eric
--
ericx
------------------------------------------------------------------------
ericx's Profile:
http://www.excelforum.com/member.php...o&userid=16860
View this thread:
http://www.excelforum.com/showthread...hreadid=320456