Thread: Click on Cell and Jump to a Sheet

Hello,

What a great forum this is....I am astonished at the level of help I receive when I have questions. Even the noobish question are met with assistance or helpfu guidance.

I am working with Excel 2010. I have a spread sheet that has multiple pages. The very first page is a snap shot of the totals of the other pages. Is it possible to hyperlink a cell on the front page and direct it to a specific sheet within the workbook?

For example - If I have a sheet named "Sales", and the front sheet total for the sheet named "Sales" is £250.....is it possible to click the £250 cell and have it jump to the sheet named "Sales"? You have to keep in mind that the cell that has the total is a calculation based on the "Sales" sheet. Another way to do it would be to use a cell in the same row that is desgination the 'jump to' cell that would jump to the sheet.

I hope this is not too confusing to follow...in re-reading it I may have made it sound harder than it needs to be.

Thanks for any help or effort put into this!

Best wishes,

Dave

Not sure i understood, but you can use HYPERLINK.

Say A2 is a text Sales. You have sheet named Sales. In B2 use

=HYPERLINK("#'"&A2&"'!A1",SUM(INDIRECT("'"&A2&"'!A:A")))

This will sum column A from the sheet entered in A2 & give a hyperlink on it's total.

if this is not you are looking, please attach a sample file.

Hi wisedave,

Read this site for your answer.
http://www.experts-exchange.com/Soft..._23558557.html