Excel, Can this even be done?

Colbaker · 7 Oct 2016 at 13:12

Hi all.

if i have a list of hyperlinks on Page one, Each hyperlink points to different part of the same workbook although on different pages, is there anyway that i could create a large merged cell on page one and that the contents of the individual hyperlink i press show in this cell?

Prefer A formula as never done VBAm Or am i thinking about this the wrong way and there is a much simpler way?

Thanks all.

D3K · 7 Oct 2016 at 13:16

why would you need to click the link? Just concatenate the cells

Code:

=Sheet2!A1 & " " &  Sheet3!A1

Colbaker · 7 Oct 2016 at 16:33

Thanks for the reply. It's kind of a help sheet. So someone would enter in the search something like "cats" below it will list all the instables from another page that refers to cats. The user then needs to click the relevant document they are looking for and return those results in the cell on page one. Thought maybe a hyperlink will work.

Not really sure what the formula does that you have posted. Kind of a noob

Bantu · 7 Oct 2016 at 17:27

so.. you have a list of topics on page 1. You'd like to have it so that when a user clicks on one of those topics instead of being transported to the relevant sheet, the information is provided to them in the cell. Is that right?

I personally think it would be easier to keep the hyperlinks and have a "return to front page" hyperlink on the other sheets.

Colbaker · 8 Oct 2016 at 11:22

Bantu said:
so.. you have a list of topics on page 1. You'd like to have it so that when a user clicks on one of those topics instead of being transported to the relevant sheet, the information is provided to them in the cell. Is that right?

I personally think it would be easier to keep the hyperlinks and have a "return to front page" hyperlink on the other sheets.

Yeah it has crossed my kind that I may well be over complicating things

.

Whilst I am here any idea what forumla I could use to enter a keyword I to cell A1 on sheet 1 which will then list all the relevant finding from sheet 2 where the data will be listed.

So for instance on sheet 2 I have a list of small sentences (only a few words) in sheet 1 cell A1 I enter the word CAT starting in cell A2 on sheet one it will list all the instances from sheet 2 that has the word CAT in it. I have tried a few ways but have limited knowledge of excel.

Thanks for the help so.far.