Inserting a string in a cell reference
down vote favorite
share [g+] share [fb] share [tw] Dear All, I have in a cell ("I8") the name of the sheet and I in another cell I want to get the value of a cell that is located in a different workbook but has the same name. So I've tried: ='[Results.xlsx]'&I8&'!$P$2 but I get an error. I've tried using " but I also get an error. I've done this already but I haven't got the excel file with me. Any advise is welcome. Kind regards, Joćo |
Inserting a string in a cell reference
hi Joćo,
the INDIRECT function will work if the file " Results.xlsx" is open =INDIRECT("'[Results.xlsx]"&I8&"'!$P$2") if not you can use a vba solution -- isabelle Le 2012-04-06 20:34, Joao Andre a écrit : down vote favorite share [g+] share [fb] share [tw] Dear All, I have in a cell ("I8") the name of the sheet and I in another cell I want to get the value of a cell that is located in a different workbook but has the same name. So I've tried: ='[Results.xlsx]'&I8&'!$P$2 but I get an error. I've tried using " but I also get an error. I've done this already but I haven't got the excel file with me. Any advise is welcome. Kind regards, Joćo |
Inserting a string in a cell reference
On Friday, April 6, 2012 7:34:33 PM UTC-5, Joao Andre wrote:
down vote favorite share [g+] share [fb] share [tw] Dear All, I have in a cell ("I8") the name of the sheet and I in another cell I want to get the value of a cell that is located in a different workbook but has the same name. So I've tried: ='[Results.xlsx]'&I8&'!$P$2 but I get an error. I've tried using " but I also get an error. I've done this already but I haven't got the excel file with me. Any advise is welcome. Kind regards, Joćo -- Joao Andre If the source wb is closed you may just use the formula referencing the sheet. Then you could use editreplaceoldsheetname with newsheetname |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com