i want to link to another sheet.. but i want to take the sheetname from a cell? like =B12!B18 :P
=Blad1!B18
i want to link to another sheet.. but i want to take the sheetname from a cell? like =B12!B18 :P
=Blad1!B18
Hi
You can do this using INDIRECT:
=INDIRECT("'" & B12 & "'!B18")
Richard
Originally Posted by RichardSchollar
thx (: