How Can I Link Sheets - Xls Download

Dear All,
I woul like to tell you that I have Vacation details sheet which calculates consumed days and balance as well as number of days since joining plus another information such like department, job title, etc.
the question is how can i linke the master sheet with another sheet that when i insert empolyee No gives me the all information concern particular employee so as to be able to print when requested from employee.
Your assistance is highly appreciated.

Hi,
Please see attached Excel file in which I mentioned how to give link to other sheets.
If you have another query then please attach your excel file with query.

Hi,
Sorry, Please check attached file.............

Hi,
You just check the file which is I already attached.
in that file if you click on Sheet2 option it will go in sheet 2 in same book
also if you click on Sheet3 option it will go in sheet 3 in same book.
First check it if other query ask.........

A simple Google search would have given you the answer immediately.
linking spreadsheets in excel - Google Search

Dear All
To add the the above question, how do i link the two sheet, so that data which is feeded in one sheet gets automatically updates in the othe sheet.
Regards
Jeevan

Hi Jeevan,
You can use lookups for that to gets automatically updates in the other sheet.
For more details You attach your excel sheet I will give you the excat solution.

Yes Vlookup is the best option in this regard also you can extract all the details on your one and master sheet from all the other sheets.
A sample sheet has enclosed for your perusal.