Search : in
By :

Need help on Excel Macros

Last answer on Aug 21, 2009 4:50:49 pm BST Sinras, on Aug 21, 2009 9:23:55 am BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Need help on Excel Macros » in :
Excel – Macro to detect and hide blank rows Show Excel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel Macro Help Please (Solved) Show
Excel Macro for deleting rows IF cells not... Show
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
[Excel] – Running Macro Automatically Show[Excel] – Running Macro Automatically Issue Solution Issue I have a macro in excel which needs to be run twice a day and I don’t even want to open the excel sheet. How can I make this process automatic? If I can convert the macro...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download Excel Macro Processor Show
Download Super Macro ShowSuper macro is a free software which allows to create macro under Windows in order to activate diverse automatic actions. Apart being free, this software is easy to use and requires no knowledge in programming. You just simply click buttons, then...
Ask your question Reply

1

 Excelguru, on Aug 21, 2009 4:50:49 pm BST
  • +1

Use VLOOKUP(lookup_value,table_array,col_index_num,FALSE)

Lock the cells ($) in the "table_array" A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help