Hi,
I need assistance with the Excel Macro
Macro - auto populate the values based on previous cell values
I have modules in a project and the grade of the employee working for that project.
Modules are updated in column A
Employee Grades in Column B
Now, based on the values of the column A and Column B, the corresponding cell in the column C should populate the responsibilities of that employee for that module.
I need a macro to do this and not a formula or function in excel.
For your reference, I am attaching a template in this thread. The values in the last are the values that need to be populated when I select the particular module an the employee Grade. Please send me a template with the macro written. I am a novice at macro and would appreciate your help.
The values in the Column C are the values which should appear automatically when the values in the Column A and Column B are selected.
Regards,
Avinash
Bookmarks