Hi, I need some help in Excel. I want to attach two or more cells in two different sheets. For example, while making an attendance sheet, I have two sheets. What I want is when I write any name in the first sheet, it should search for the same in the second sheet and post all the resulting data from the first sheet to the second sheet under the same name in different cells. Kindly help me if possible. Here is my email: [Email Removed For Privacy Reasons].
From Pakistan, Lahore
Acknowledge(0)
Amend(0)
1From 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)
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.
Regards
From Pakistan, Lahore
Acknowledge(1)Amend(0)
Regards
From Pakistan, Lahore
Acknowledge(1)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)
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)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