Hi. I posted this on another page but wasnt sure if anyone would see it. Is it possible to have an item in a cell, say "Apples" and then be able to either click on that cell which leads to further information either on a different worksheet or as a pop up box. So say I wanted to know abit more about 'Apples' and I had information on a different worksheet, could I click on the Apples cell and it would take me to that information? Apologies for my ridiculous examples. Kind of like a portal.
Thought i should also add, that the pop up information/linked information would need to be editable over time as well. Say on a monthly basis I would need to update that information.
For example B2 contains "Apples" when I double click on it, it leads to another page/popup which tells me,
what kind of apples there are
how expensive they are
where you can purchase Apples
Thanks for the help
Thought i should also add, that the pop up information/linked information would need to be editable over time as well. Say on a monthly basis I would need to update that information.
For example B2 contains "Apples" when I double click on it, it leads to another page/popup which tells me,
what kind of apples there are
how expensive they are
where you can purchase Apples
Thanks for the help
