| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to other sheets (depending of a cell)
Hi! I have a problem to make a link to an other sheet depending of what you write in a cell. If you write "sheet2" in a specific cell I want to have "sheet2" in the link! Ex: I write "sheet3" in cell D2. In an other cell I want a link like "[Object1.xls]D2$B$1. D2=depending of what you write in D2! In this ex. should the link be: [Object1.xls]sheet3!$B$1 Help me please!! -- petterss ------------------------------------------------------------------------ petterss's Profile: http://www.excelforum.com/member.php...o&userid=36354 View this thread: http://www.excelforum.com/showthread...hreadid=561379 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking to other sheets (depending of a cell)
Hi petterss,
=INDIRECT("[Object1.xls]" & D2 &"!$B$1") should be what you're looking for. Regards, Ingolf petterss schrieb: Hi! I have a problem to make a link to an other sheet depending of what you write in a cell. If you write "sheet2" in a specific cell I want to have "sheet2" in the link! Ex: I write "sheet3" in cell D2. In an other cell I want a link like "[Object1.xls]D2$B$1. D2=depending of what you write in D2! In this ex. should the link be: [Object1.xls]sheet3!$B$1 Help me please!! -- petterss ------------------------------------------------------------------------ petterss's Profile: http://www.excelforum.com/member.php...o&userid=36354 View this thread: http://www.excelforum.com/showthread...hreadid=561379 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| please help! Linking a picture to a cell and recalculating automatically | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
| Changed referenced cell between sheets | Excel Discussion (Misc queries) | |||
| How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
Linear Mode
