Closed Thread
Results 1 to 2 of 2

Macro - auto populate the values based on previous cell values

  1. #1
    Registered User
    Join Date
    07-17-2009
    Location
    India
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    13

    Exclamation Macro - auto populate the values based on previous cell values

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Macro - auto populate the values based on previous cell values

    Please don't start multiple threads for the same issue. This thread is being closed.

    http://www.excelforum.com/excel-prog...ll-values.html

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1