Definining a name please help

  • Thread starter Thread starter TwEaKFrEaK
  • Start date Start date
T

TwEaKFrEaK

Whats up everyone, I need some help.

Here is the scenario, I have 2 workbooks call then data and results.
send out the data book to customers to fill out. The results workboo
houses all the data I receive back.

What I would like to know is how can I set a name to reflect a specifi
cell which has a formula in it.

For example

Name = Cell C6

C6 has this formula

='S:\Local Disk\[Testfile.xls]Performance'!$A$2:$J$402

I want
Name to equal ='S:\Local Disk\[Testfile.xls]Performance'!$A$2:$J$402

Any ideas or help?

Thanks again people you are all very helpfu
 
Hi
not sure what you're trying to achieve with this. What do you want to
do with this defined name?
 
Thanks for your reply Frank, here is my original example

For example
Name = Cell C6

C6 has this formula

='S:\Local Disk\2004\[Testfile.xls]Performance'!$A$2:$J$402

I want
Name to equal ='S:\Loca
Click to expand...
Disk\2004\[Testfile.xls]Performance'!$A$2:$J$402

Some of the fomula in C6 changes every month, either filename, o
year, etc. So I created an input sheet that captures the filename
year etc and concats them.

I would like the defined names to be linked back to a cell with th
concated value therefore when I change the year on the input sheet al
the defined names will change. Which will make my lookup tables captur
the newest data when I change the input sheet.

I tried using the indirect function and it didnt work. Plus I need th
data sheet to keep the lookup values even if the other workbooks ar
closed.

Any help would be great
 
Hi
still not quite sure what you want. But if you want to use INDIRECt it
probably won't do as INDIRECT does not work for close workbooks. See
the following link for alternatives (e.g. INDIRECT.EXT for a SINGLE
cell reference)
http://tinyurl.com/2c62u


--
Regards
Frank Kabel
Frankfurt, Germany

TwEaKFrEaK > said:
Thanks for your reply Frank, here is my original example

For example
Name = Cell C6

C6 has this formula

='S:\Local Disk\2004\[Testfile.xls]Performance'!$A$2:$J$402

I want
Name to equal ='S:\Local
Click to expand...
Disk\2004\[Testfile.xls]Performance'!$A$2:$J$402

Some of the fomula in C6 changes every month, either filename, or
year, etc. So I created an input sheet that captures the filename,
year etc and concats them.

I would like the defined names to be linked back to a cell with the
concated value therefore when I change the year on the input sheet all
the defined names will change. Which will make my lookup tables capture
the newest data when I change the input sheet.

I tried using the indirect function and it didnt work. Plus I need the
data sheet to keep the lookup values even if the other workbooks are
closed.

Any help would be great.
Click to expand...
 
Back
Top