Work Sheet Association

C

Chrispy

HI: Here's what I need to do, I need to create a Primary page containing
various information as a selection sheet where If I should need to purchase
say pasta but there are 50 different kinds of pasta I want to click on the
first sheet and then after I do have it take me to another sheet listing the
50 different kinds of pasta.


HELP PLEASE!!!!!
 
G

Gary''s Student

Put the list of pastas in a worksheet called pasta and then:

Insert > Hyperlink > To a place in this document > and then pick a right
cell in the pasta sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking sheets which must update the date first. 3
multiple work sheet data to link in one worksheet 6
How to paste data to alternating cells down a column? 1
nesting help 3
Vlookup to total hours billed 1
Excel vba code to match duplicates 4
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Covert Text String Data 1

Top