Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to a worksheet within the same folder
Hello - I am building an competitive repository and I want to have a first
sheet summary page of a complete list of companies and then create link (on the summary page) to a complete description of that company located on another sheet within the same file? Can I do that? If so how? -- Sally |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to a worksheet within the same folder
VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 10:49:00 -0700, SallyM wrote: Hello - I am building an competitive repository and I want to have a first sheet summary page of a complete list of companies and then create link (on the summary page) to a complete description of that company located on another sheet within the same file? Can I do that? If so how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save worksheet to a folder | Excel Discussion (Misc queries) | |||
How do I link an Excel worksheet to a folder? | Excel Discussion (Misc queries) | |||
Linking snaps in a folder to cells | Excel Discussion (Misc queries) | |||
Linking cells to files in a folder | New Users to Excel | |||
linking an excel document to my task folder in outlook | Excel Discussion (Misc queries) |