Link to one worksheet to another worksheet in same workbook

R

Rupesh Ayare

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.
 

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

Top