range that is available everywhere

M

mithu

I have a list that has the monthly revenue for 300 companies.

what i have done is put these in my personal.xls file. and setup a
range name for them.

so if i ever need to pull these numbers from any spreadsheet i can get
them by typing

=vlookup(a2,personal.xls!uptofeb,12,false)

this gets me the revenue for whichever id is in a2 and pulls data from
column 12 in personal.xls ..

is there anyway i can get it so that i only have to put the range name
in the target array.

so i only have to put.. =vlookup(a1,uptofeb,12,false) and it pulls
the data from personal.xls by it self?
 
M

meatshield

Assuming I'm reading this correctly, you could probably make a new
named range that references the old one.
UptoFeb2 =personal.xls!uptofeb
then use =Vlookup(a1,uptofeb2,12,false)
 
M

mithu

but that named range will only work for that worksheet correct? what
if i wanted the range name "uptofeb" to be avaiable in any spreadsheet
that i open?
 
Top