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
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
From United Kingdom
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
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
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
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
From United Kingdom
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.