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