R
Russell
Is it possible to Concatenate two or more cells to create a formula?
I.e. I would like to create a formula that references cells in a
seperate workbook. Using multiple cells to enter in variable data, I
would like to combine those to create the final formula such as:
CONCATENATE("'",c:\my documents\,apples01.xls',!red)
would combine into
'c:\my documents\apples01.xls'!red
I would like to then be able to change the apples01 to apples02 in the
next row to pick from the second spreadsheet. But using concatenate
returns a text string. How do I force it to retun it as a formula?
Thanks
I.e. I would like to create a formula that references cells in a
seperate workbook. Using multiple cells to enter in variable data, I
would like to combine those to create the final formula such as:
CONCATENATE("'",c:\my documents\,apples01.xls',!red)
would combine into
'c:\my documents\apples01.xls'!red
I would like to then be able to change the apples01 to apples02 in the
next row to pick from the second spreadsheet. But using concatenate
returns a text string. How do I force it to retun it as a formula?
Thanks