Referencing File Path - Dynamic Cell Input for Worksheet

Chomie

New member
Joined
Dec 23, 2013
Messages
1
Reaction score
0
Points
0
Hello,

I have the following formula:

Code:
='[workbook2.xlsx][B][COLOR=#ff0000]sheet1[/COLOR][/B]'!$I$53/1000

In workbook1 that references workbook2 having multiple worksheets (sheet1,sheet2,sheet3,etc....)

What I would like to do is reference a cell in workbook1 that contains the correct sheet number (ie. if I type "sheet2" in cell A1,workbook1, it will reference workbook2,sheet2)

Something like this:

Code:
='[workbook2.xlsx][B][COLOR=#ff0000]&A1&[/COLOR][/B]'!$I$53/1000

where A1 = sheet2

Is this possible? I have seen the INDIRECT() function being thrown around but used in context of referencing the filepath location, not the sheet name after the file location.

Thanks in advanced,
Chomie.
 
Top