Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to one worksheet to another worksheet in same workbook
I have six worksheets in a single workbook. My fisrt worksheet contains
country Name and my second worksheet contains a link file listing all Detail of that country. I want to hide another five excel worksheet and give link to primary worksheet of country name without hyperlink, so, how can it possible? worksheet 1 COUNTRY ALGERIA UGANDA TANZANIA KENYA LIBYA worksheet 2 COUNTRY: ALGERIA RECEIVE DATE & TIME RECEIVE DATE & TIME RECEIVE DATE & TIME RECEIVE DATE & TIME RECEIVE DATE & TIME RECEIVE DATE & TIME VISIT OCT NO OF VISIT: 117 DATA SHOULD BE ARRIVAL 5/11/2008 5/11/2008 DATA ARRIVAL 5/11/2008 5/11/2008 DELIVERY END 18/11/08 END OF FIELD 20/11/08 IMDB 1 LOAD OF PRODUCT.TXT 5/11/2008 2 PRINT OF LOADING REPORTS/DIFFERENCES/€¦ 3 IMDB UPDATE-NEW PRODUCTS, CHARACTERISTICS 4 DIFFERENCE CHECK&CORRECT 7 EXPORT IMDB INTO RDM RDM APPLY FROM PDM PREVIOUS PERIOD 6/11/2008 1 DEFINE A NEW PERIOD 6/11/2008 2 LOAD OF IMDB 6/11/2008 SCF RECIVED 3/11/2008 3 LOAD OF SCF 6/11/2008 4 LOAD OF RAQV (Refresh) 6/11/2008 5 LOADING REPORTS CHECK 6/11/2008 6 PRICE FIXING (ONLY RUN) 6/11/2008 9 CHECK AND CORRECT PRICES 6/11/2008 Using the above example, when the user click on contry name €śAlgeria€ť and respective country on the first worksheet, I need a function in the next cell to possibly show the user all the entities from worksheet 2,3,4,5,6 respectively that match that shows details of that country. -- Regards, Rupesh Ayare |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link from worksheet in one workbook to worksheet in another workbo | Excel Discussion (Misc queries) | |||
Link from worksheet in one workbook to worksheet in another workbo | New Users to Excel | |||
Find & Replace a link to another worksheet in the same workbook | Excel Worksheet Functions | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions |