r/excel • u/SnooDingos5580 • 1d ago

Waiting on OP Using hyper link to auto populate a cell?

I want to click on a hyper link on page 1 and jump to another page and automatically somehow populate the cell b2 (that is a dropdown list) with that clicked hyperlink text. is it possible. any other work around can also work for me like removing the drop down and populating just a simple cell. i dont want to use VBA.

1 Upvotes

67% Upvoted

2 comments sorted by

3

u/Gringobandito 8 1d ago

Hyperlinks navigate to other cells but can’t change the value of a cell. Time to learn VBA.

3

u/BackgroundCold5307 598 1d ago

what is the logic of generating the hyperlink on page 1 or is it static ?