Previous Topic Next Topic

Need help on Excel Macros

Closed
Sinras - Aug 21, 2009 at 04:23 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 21, 2009 at 11:50 AM
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
Related:

1 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 21, 2009 at 11:50 AM
Use VLOOKUP(lookup_value,table_array,col_index_num,FALSE)

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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses