How can I generate bookmarks in Excel automaticaly?

Question

I have an excel spreadhseet. first sheet stores days like so:

day1 | option | date
day2 | option | date
day3 | option | date

second sheet stores evens for each day, like so:

day1 |
time | event1
time | event2
day2 |
time | event1
time | event2
time | event3


How can I automatically make excel take me to the correct day in second sheet when I press a day in sheet one? So if I press on "Day 2" on spreasheet1 it should take me to the Day 2 on spreadsheet 2.


thanks.

Please note that I know how to insert Bookmarks. What iw ant to do is to generate those bookmarks automaticaly. if I have 1000 days I want them all automaticaly link with corresponding A row in the secons sheet.

Answer 1

There is a function called HYPERLINK, not Insert > Hyperlink

you can use it along with ADDRESS, INDIRECT, MATCH, VLOOKUP or OFFSET to do it
I actually did it, but I need to know some more details.
I will be glad to help, mail me

Enjoy my profile, I am the VBAXLMan

Answer 2

Click insert/hyperlink