| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL string-how to reference cell/range | Excel Programming | |||
| String with Cell Reference | Excel Programming | |||
| freeze cell reference when inserting a row | Excel Discussion (Misc queries) | |||
| reference to a cell within a string | Excel Programming | |||
| inserting a formula with reference to a new sheet in a cell using VBA | Excel Programming | |||
Threaded Mode
