PDA

View Full Version : linking problem..



JmE
11-27-2007, 11:50 AM
i want to link to another sheet.. but i want to take the sheetname from a cell? like =B12!B18 :P

=Blad1!B18

RichardSchollar
11-27-2007, 01:12 PM
Hi

You can do this using INDIRECT:

=INDIRECT("'" & B12 & "'!B18")

Richard

JmE
11-27-2007, 10:06 PM
Hi

You can do this using INDIRECT:

=INDIRECT("'" & B12 & "'!B18")

Richard



thx (: