Dear All,
I would like to inform you that I have a Vacation Details sheet which calculates consumed days, balance, number of days since joining, and other information such as department, job title, etc.
The question is, how can I link the master sheet with another sheet so that when I insert an employee number, I receive all the information regarding that particular employee, enabling me to print when requested by the employee.
Your assistance is highly appreciated.
From Saudi Arabia, Mecca
Acknowledge(0)
Amend(0)
I would like to inform you that I have a Vacation Details sheet which calculates consumed days, balance, number of days since joining, and other information such as department, job title, etc.
The question is, how can I link the master sheet with another sheet so that when I insert an employee number, I receive all the information regarding that particular employee, enabling me to print when requested by the employee.
Your assistance is highly appreciated.
From Saudi Arabia, Mecca
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
62From United Kingdom
Acknowledge(0)Amend(0)
Hi, you just checked the file that I already attached. In that file, if you click on the Sheet2 option, it will go to Sheet 2 in the same book. Also, if you click on the Sheet3 option, it will go to Sheet 3 in the same book. First, check it. If you have any other queries, feel free to ask.
From United Kingdom
Acknowledge(0)Amend(0)
From United Kingdom
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From United Kingdom
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee Data - Format.xls
Employee Information form.doc