+ Reply to Thread
Results 1 to 4 of 4

Selecting Data in one Column automatically places data in another column.

  1. #1
    Registered User
    Join Date
    01-03-2011
    Location
    Birmingham, Alabama
    MS-Off Ver
    Excel 2010
    Posts
    8

    Selecting Data in one Column automatically places data in another column.

    Hello,

    I am attempting to create a worksheet in where a user select a value from a drop down in one column and it enters data into the column next to it.

    To explain further:

    We have system codes (AA for example), That are acronmys for system descriptions, (Atomizing Air)

    So what I would like is that when user selects AA from the drop down in one column it automatically places Atomizing air in the column next to it.

    Any ideas?
    Last edited by SirDrums; 01-03-2011 at 12:40 PM.

  2. #2
    Registered User
    Join Date
    01-03-2011
    Location
    Birmingham, Alabama
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Selecting Data in one Column automatically places data in another column.

    Sorry about that.

  3. #3
    Registered User
    Join Date
    01-03-2011
    Location
    Birmingham, Alabama
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Selecting Data in one Column automatically places data in another column.

    Anyone have any advice on this?

    I am new to coding in excel so I guess this could be a simple concept.

    TO explain further/better

    I have to columns on my main worksheet:

    System Code and System

    The cells under the columns have drop downs in them that are fed by two columns on the second sheet.

    They match up exactly:

    AA Atomizing Air

    EN Excel newbie

    etc

    I would like it so that when someone selects AA in the drop down, it automatically places Atomizing air in the cell next to it (system). I have done some reading on the match function but haven't really found and example that deals with what I am trying to do.

  4. #4
    Registered User
    Join Date
    01-03-2011
    Location
    Birmingham, Alabama
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Selecting Data in one Column automatically places data in another column.

    Ok

    I have figured out how to match up the data using this formula:

    = VLOOKUP(F2, SystemDescription, 2, 0)

    But this has to be pasted into every cell.

    I do not know how many cells there will be in any given instance of the spread sheet. What I would like to have is a macro that if it sees a value in one cell, it automatically copy/pastes the formula into the proper cell

    is this possible?

+ Reply to 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