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 |
All times are GMT +1. The time now is 12:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com