pommesmitmayo
New Member
- Joined
- Jun 12, 2011
- Messages
- 23
Hi all, hope well.
I've been trying to get something done with a hyper link that so far has evaded me whether I try with the built in insert function or the formula method.
Description;
I have a spreadsheet and in cell A1 of 'sheet1' tab is where I want to place my hyperlink.
Cell A2 is the cell I use for data validation that sets up some other aspects of the sheet.
The Database tab is where I have a range of info about my clients.
To paraphrase I want the hyperlink cell to take me to a cell that changes depending on the selection in sheet A2.
So. If I have customer 6 selected and click the hyperlink, it takes me to cell B7 in sheet2.
But if I have customer 12 selected and click that same hyperlink, it takes me to cell B13 in sheet2.
Is this possible without using VBA or something exotic?
Thanks.
I've been trying to get something done with a hyper link that so far has evaded me whether I try with the built in insert function or the formula method.
Description;
I have a spreadsheet and in cell A1 of 'sheet1' tab is where I want to place my hyperlink.
Cell A2 is the cell I use for data validation that sets up some other aspects of the sheet.
The Database tab is where I have a range of info about my clients.
To paraphrase I want the hyperlink cell to take me to a cell that changes depending on the selection in sheet A2.
So. If I have customer 6 selected and click the hyperlink, it takes me to cell B7 in sheet2.
But if I have customer 12 selected and click that same hyperlink, it takes me to cell B13 in sheet2.
Is this possible without using VBA or something exotic?
Thanks.
Test.xlsx | |||
---|---|---|---|
A | |||
2 | Customer 6 | ||
sheet1 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
A2 | List | =sheet2!$A$2:$A$21 |