Report from Excel Data Sheet

Solved/Closed
ram sharma - May 17, 2011 at 02:04 AM
 ram - May 21, 2011 at 08:21 PM
Dear Sir,

I am new in excel. I am trying to use excel for my work easier.
I have one excel file where there are different sheet of monthly salary of different employee. Employee may define unique ID.
May I use some VB formula (other if any) for knowing individual employee detail salary for different month.
I am so thankful if I found some help.

3 replies

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
May 17, 2011 at 10:15 AM
Hi Ram,

Yes you may.
Phew, that was an easy question. haha

Try Vlookup.
=Vlookup(Employee name, Matrix of employee's and salary's, column in which the salary is found).
Use help for more info on Vlookup.

Does this help?

Best regards,
Trowa
0
Sir

I am unable to see your answer.
what happen, Please suggest me.

thanks
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
May 19, 2011 at 09:08 AM
Hi Ram,

Strange, can you see it now?

Try Vlookup.
=Vlookup(Employee name, Matrix of employee's and salary's, column in which the salary is found).
Use help for more info on Vlookup.

Does this help?

Best regards,
Trowa
0
Thanks ,
I am able to done what I want to do.

ram
0