View Poll Results: Is the information provided in the query enough to solve the issue?

Voters
0. This poll is closed
  • Issue description

    0 0%
  • Issue resolution

    0 0%
  • Issue example

    0 0%
  • Issue Overview

    0 0%
Closed Thread
Results 1 to 5 of 5

Macro to auto populate the destination cell based on the values of the previous cell

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

    Exclamation Macro to auto populate the destination cell based on the values of the previous cell

    Hi,

    I need assistance with a scenario for writing a macro.

    The data in the third cell should auto populate based on the values of the data in the first and 2nd columns.

    I do not want to use the If condition. I need a macro to do this job because, i have a very long list of modules and the responsibilities.

    I am attaching the Data for which I need assistance. Please give me a template to do this job. I am a novice at Macro programing and hence cannot understand if u just give me the codes. Please send me the template. I will modify the template based on further modules required.

    AB
    Attached Files Attached Files

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Macro to auto populate the destination cell based on the values of the previous c

    I looked at your example, and I don't understand. What is supposed to be populating? All your columns are filled out already.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

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

    Re: Macro to auto populate the destination cell based on the values of the previous c

    When I select the data in the first and second column, the data which I gave in the third column should populate in that place. I gave the values of the third column which needs to be populated.

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

    Re: Macro to auto populate the destination cell based on the values of the previous c

    Hi Dave,

    The values int he column C are the values which should auto populate. I have already populated them just for reference.

    Regards,
    Avinash

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

    Re: Macro to auto populate the destination cell based on the values of the previous c

    Thread being closed as a duplicate. Please don't create any more duplicates of this scenario.

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

    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