Need help on Excel Macros [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I am not a techie and I have very limited knowledge on Excel Macros.

I have two worksheets.

Worksheet 1 - Employee information like Employee ID, Name, Department, Gross Salary, Tax Information, etc
Worksheet 2 - Employee information again

My requirement is:

If I enter Employee ID in a cell in Worksheet 2, I should automatically get limited information like Department and Gross Salary from Worksheet 1.

Please help.

Regards
Sinras

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Use VLOOKUP(lookup_value,table_array,col_index_num,FALSE)

Lock the cells ($) in the "table_array"
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!