Linking Sheet to a Cell in a Index Sheet.

Dear Friends,
I have a file with more then 75 sheets for which I have created a Index Sheet showing Results in the particular Data Sheet. I want to go to that particular Data Sheet when I activate the corresponding cell in Index Sheet and back to Index Sheet after viewing/Modifying the Data Sheet.
Regards,

You can use a HYPERLINK formula like this in A1 of each of your Data Sheets:

=HYPERLINK("#Index Sheet!A1,"Click to Return to Index Sheet")

which will show the text in the second string and send your cursor to A1 of the Index sheet if you click on that cell.

You can have a similar formula in your Index Sheet, but the sheet name will need to be changed for each of your 75 sheets (and you might like to jump to a different cell than the one containing the first formula).

Hope this helps.

Pete

Thanks Pete,
Do you have a VBA code so that by a combination key will take to Index Sheet instead of Creating Hyperlink in all sheets whic get printed in print outs.

Regards,

Thank you very much Pete and Sisthsense,
Combination of suggestions made by you two is working perfectly as I wanted. Using Hyperlink from Index Sheet to go to Data Sheet and macro to return back to Index Sheet.