Name in cell ref used in a formula
As long as i can get Excel do what i want it do i'm interested!
thanks
"T. Valko" wrote:
Would this then referrence the external spreadsheet correctly or am i stuck
using the full name?
There is a way to do it the way you want with built-in functions *BUT* the
referenced file *MUST* be open. This is usually a "deal breaker"!
There are a couple of other methods that might work on the closed file but
these require VBA routines and one is an add-in. Still interested?
--
Biff
Microsoft Excel MVP
"Phendrena" wrote in message
...
Hello,
I have the following formula (this is only a part of the formula) :
=SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops
Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe
Bloggs.xls]Mid-Term'!$B$3:$B$503)=12)
I have Joe Bloggs as a name in the formula and also in a cell.
Can i use the cell referrence, such as C6 instead of the name? Would this
then referrence the external spreadsheet correctly or am i stuck using the
full name?
So it would read [MTC Tool - "Cell Ref".xls]
Thanks,
|