Indirect Function

0
votes

I am wondering how I get the data from workbook 1 to workbook2 using the indirect function.

I have this formula currently, but it doesn't work - I am trying to rectify this, someone else built the spreadsheet. 

=INDIRECT("'[Workbook1.xlsm]"&$A$1&"'!A"&ADDRESS(ROW(),COLUMN(),4))

This is for a cell reference that is subject to change:

&$A$1&

Links to the workbook are below.

Workbook(1): https://ibb.co/gfFASn Workbook(2): https://ibb.co/h4DfSn I accept that I am probably incorrect with my code.

The difference is useful answers where given for the clearer explanation I have made to my problem with this question.

1
excelexcel-formulaexcel-2016
Possible duplicate of Indirect function not working- - Ron Rosenfeld

1 Answers

1
votes

I think you have an extra A in your cell reference which follows your sheet name - try this instead:

=INDIRECT("'[Workbook1.xlsm]" & $A$1 & "'!" & ADDRESS(ROW(),COLUMN(),4))