is there a way to get data from another workbook by having the file named
from a cell? ex: have a cells w/ file name which should refer to the file i
want to pull the data from.
abc & xyz are file names and data in cells. abc is in cell G1 and xyz is in
cell H1. I want to create a formula that will call upon the files
[abc.xls]data!a1 or [xyz.xls]data!a1 by refering to the cell G1 or H1
I've already tried to get the data this way: =[(G1).xls]data!a1 for my
abc data
Is there a way to do this???