Hi all
My first post on the forum and hopefuly not the last.
I've searched around and couldn't find what i need...
So heres what i need help with:
I've got X number of Sheets named Sheet1,Sheet2,...Sheet5
Sheet1:
Sheet2:A1 = a number
B1 = VLookup(A1;Sheet2!A1:B3;2)
C1 = Hyperlink to SheetX according to the number inserted on A1
This is the example of matrix i have:
So i really need help on Sheet1 C1 as above. I want that when i change the value on A1 the C1 changes the sheet it needs to goA1 = 3
A2 = 5
A3 = x
B1 = Hat
B2 = Plain
B3 = xxxx
Imagine:
Well thats the best i can explain i guess...A1 = 3 on C1 = Hyperlink to Sheet 3
So
If i put on A1 = 7 on C1 would show up the Hyperlink to Sheet 7
Or
AX = x on CX = Hyperlink to Sheet X
Sorry for my bad english and the lack of experience on this subject.
Hope to get some help
Cheers
Bookmarks