Using Indirect Function to link to Other Files

T

Timmy Mac1

Is this possible?

I have a situation whereby I want to use one generic spreadsheet to
create results for different data sets.

The different data sets are contained in different files.

I need to bring in each data set into the generic spreadsheet and then
save it as a specific spreadsheet for that data set.

I thought a way of doing this might be bring in the data by means of a
straightforward cell reference eg formula = '[dataset1!]SHEET1'!A1.

To make things easier I would like to use the INDIRECT function instead
of the actual file name so that I can change all the cells by changing
one.

Is this possible?

Thanks
tt
 
B

Bob Phillips

INDIRECT will only work with open files.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Use of the Indirect function on a closed workbook. 6
SUMIF and INDIRECT reference to tab in other workbook 3
Indirect or substitute? 7
use of the indirect function? 4
Indirect and sumif functions with multiple workbooks 1
Referencing a tab NUMBER rather than the tab NAME in a formula 1

Top