Formula to get data from files

[greasybob]

I'm needing to list file names in column A, cell references in column B
and have the results in column C.
(Then when I change A or B, the C data will reflect the changes)
Thank

 

[Frank Kabel]

Hi
are the other files opened or closed?

 

[Guest]

Assuming A1 contains "Filename.xls" and B2 contains "G123"

In cell C1, enter this formula:

=CONCATENATE(A1,B1) returns "Filename.xlsG123"

If you want to enter a space between entries, ...(A1," ",B1) returns
"Filename.xls G123"

copy this formula down as needed

HTH

swatsp0p

 

[Dave Peterson]

The function that you'd want to use is =indirect(), but that function will
return an error if the "sending" workbook is closed.

But Harlan Grove wrote a UserDefinedFunction that may help you:
http://www.google.com/[email protected]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm