goldeneyes20006
1

hi i need some help in excel.
i want to attach 2 or more cells in 2 different sheets. for example
while making a attendance sheet i have two sheets and what i want is when i write any name in 1st sheet it search the same in 2nd sheet and post all the resulted data from 1st sheet to 2nd sheet under the same name in different cells.
kindly help me if possible .
here is my e.mail
goldeneyes20006@yahoo.com

From Pakistan, Lahore
amitavamaj
5

Possible through the use of VLOOKUP/HLOOKUP function in Excel. For more, send some sample data. Regards Amitava 9830990154
From India, Calcutta
goldeneyes20006
1

Dear amitavamaj
thanks for the help but i think that is not what i want or may be i don't understand how to use it. so here is the sample file for what i want .... i hope u can help me.
goldeneyes20006 on yahoo

From Pakistan, Lahore
Attached Files (Download Requires Membership)
File Type: xls Attendance Sheet 1.xls (31.0 KB, 569 views)

nashbramhall
1624

Sorry,
Your question is not clear; there are no numerical data in Q4:Q17 in your sheet 2. How can you compare oranges and apples?
Have a nice day
Simhan
Leaning and Teaching Fellow (Retd)
The University of Bolton, UK
Chief Advisor, Promentor-consulting

From United Kingdom
boss2966
1168

Please use HLOOKUP and VLOOKUP to bring the data you want to get in the sheet as advised by Amitava.
From India, Kumbakonam
goldeneyes20006
1

Hi
basically am trying to manage employees Annual Leave Record and I dint want to compare anything but infect I want to save time.For this I want when I enter data in sheet1, resulted data automatically enter in annual sheet in front of the same month which I mention in sheet1.
for example
if i write March in sheet1 the resulted data automatically enter in-front of March in Annual sheet. annual requirement are only two Leave Avail and renaming leave.
Hope u guys understand.
Regards

From Pakistan, Lahore
groyalg
58

Dear Saima,
Please refer the below provided link:
https://www.citehr.com/397346-excel-...ormulae-2.html

From India, Delhi
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.