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
1i 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
Possible through the use of VLOOKUP/HLOOKUP function in Excel. For more, send some sample data. Regards Amitava 9830990154
From India, Calcutta
From India, Calcutta
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
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
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
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
Please use HLOOKUP and VLOOKUP to bring the data you want to get in the sheet as advised by Amitava.
From India, Kumbakonam
From India, Kumbakonam
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
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
Dear Saima,
Please refer the below provided link:
https://www.citehr.com/397346-excel-...ormulae-2.html
From India, Delhi
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.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls