Hi, I need some help in Excel.
I want to attach 2 or more cells in 2 different sheets. For example, while making an attendance sheet, I have two sheets. What I want is when I write any name in the 1st sheet, it should search for the same in the 2nd sheet and post all the resulting data from the 1st sheet to the 2nd sheet under the same name in different cells.
Kindly help me if possible. Here is my email: goldeneyes20006@yahoo.com.
From Pakistan, Lahore
Acknowledge(0)
Amend(0)
1I want to attach 2 or more cells in 2 different sheets. For example, while making an attendance sheet, I have two sheets. What I want is when I write any name in the 1st sheet, it should search for the same in the 2nd sheet and post all the resulting data from the 1st sheet to the 2nd sheet under the same name in different cells.
Kindly help me if possible. Here is my email: goldeneyes20006@yahoo.com.
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Possible through the use of VLOOKUP/HLOOKUP function in Excel. For more, send some sample data. Regards Amitava 9830990154
From India, Calcutta
Acknowledge(0)Amend(0)
From India, Calcutta
Acknowledge(0)Amend(0)
Dear Amitavamaj,
Thank you for the help, but I think that is not what I want. Or maybe I don't understand how to use it. So here is the sample file for what I want... I hope you can help me.
Goldeneyes20006 on Yahoo
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Thank you for the help, but I think that is not what I want. Or maybe I don't understand how to use it. So here is the sample file for what I want... I hope you can help me.
Goldeneyes20006 on Yahoo
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Sorry,
Your question is not clear; there are no numerical data in Q4:Q17 on your sheet 2. How can you compare oranges and apples?
Have a nice day.
Simhan
Learning and Teaching Fellow (Retd)
The University of Bolton, UK
Chief Advisor, Promentor-Consulting
From United Kingdom
Acknowledge(0)Amend(0)
Your question is not clear; there are no numerical data in Q4:Q17 on your sheet 2. How can you compare oranges and apples?
Have a nice day.
Simhan
Learning and Teaching Fellow (Retd)
The University of Bolton, UK
Chief Advisor, Promentor-Consulting
From United Kingdom
Acknowledge(0)Amend(0)
Please use HLOOKUP and VLOOKUP to bring the data you want to get in the sheet as advised by Amitava.
From India, Kumbakonam
Acknowledge(0)Amend(0)
From India, Kumbakonam
Acknowledge(0)Amend(0)
Hi,
Basically, I am trying to manage employees' Annual Leave Record, and I don't want to compare anything. Instead, I want to save time. For this, when I enter data in sheet1, I want the resulting data to automatically enter in the annual sheet in front of the same month mentioned in sheet1.
For example, if I write "March" in sheet1, the resulting data should automatically enter in front of "March" in the Annual sheet. The annual requirements are only two: Leave Available and remaining leave.
Hope you guys understand.
Regards
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Basically, I am trying to manage employees' Annual Leave Record, and I don't want to compare anything. Instead, I want to save time. For this, when I enter data in sheet1, I want the resulting data to automatically enter in the annual sheet in front of the same month mentioned in sheet1.
For example, if I write "March" in sheet1, the resulting data should automatically enter in front of "March" in the Annual sheet. The annual requirements are only two: Leave Available and remaining leave.
Hope you guys understand.
Regards
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Dear Saima,
Please refer to the link provided below:
https://www.citehr.com/397346-excel-...ormulae-2.html
From India, Delhi
Acknowledge(0)Amend(0)
Please refer to the link provided below:
https://www.citehr.com/397346-excel-...ormulae-2.html
From India, Delhi
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Employee Data - Format.xls