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.

From Saudi Arabia, Mecca
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.
From United Kingdom
Hi, Sorry, Please check attached file.............
From United Kingdom
Attached Files (Download Requires Membership)
File Type: xls Links.xls (34.5 KB, 1132 views)

Anonymous
62

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.........

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

From Australia, Melbourne
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
From India, Mumbai
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.
From United Kingdom
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.
From India, Gurgaon
Attached Files (Download Requires Membership)
File Type: xls Sample-Vlookup Example.xls (55.5 KB, 704 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.