+ Reply to Thread
Results 1 to 5 of 5

Multiple choice displaying the results of 2 cells into 2 different cells

  1. #1
    Registered User
    Join Date
    05-05-2007
    Location
    Palmdale, CA
    Posts
    10

    Multiple choice displaying the results of 2 cells into 2 different cells

    I have an excel spreadsheet that I use for quoting new computer system builds. I'm trying to have it where when i select a cell that it will automatically display the part name in one cell and the cost in a cell next to the name.

    for example:

    i want to have the parts listed under the A column and the price listed under the C column. I have a selection of between 3 and 5 parts for each component listed next to it one the same sheet, the part names under the "I" Column then an empty cell (Column "J" what I want to use to select the item)then the price of the item the "K" Column.

    for like the processor i have 4 different models to pick from, each listed on a different row. (Name of item listed in I1 and and its price in K1, then the next model in I2 and K1 and so on) when I pick the processor i want to use in the quote by putting a X or a 1 on in the "J" Column it will put the name of the processor in the A column on the same row and the price in the "C" column

    Plz any help on this would be appricated....GREATLY!!

    I already have the sheet set up to total the price of the parts in the "C" Column but I'm stuck at this point.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    The following macro should help.

    It needs to be pasted into the tab in the VBA editors (ALT F11) for the sheet on which your figures are

    Please Login or Register  to view this content.
    This is slightly more elaborate that what you asked for as it will delete a line if you remove the selection.

    It's not fully bullet proofed so needs to be used with care.
    Martin

  3. #3
    Registered User
    Join Date
    05-05-2007
    Location
    Palmdale, CA
    Posts
    10
    Thanks, I'll give that a try. I would still like to see if i can do it without the macro, I have this on a Small business server and our antivirus/antimalware protection flags any macros.

    EDIT: attaching a copy of the file
    Attached Files Attached Files
    Last edited by JustCofox; 05-07-2007 at 06:50 PM. Reason: attaching file

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Having now seen your file, the previously supplied macro will not work. I was unaware that you had merged cells within the sheet.

    Please let me know if you need a new version.

  5. #5
    Registered User
    Join Date
    05-05-2007
    Location
    Palmdale, CA
    Posts
    10
    Thanks for the reply, I still havent had any luck getting the info displayed how i need it to be, I dont have much experience with excel or VB. so if you have any other suggestions please. if i need to remake the sheet i can

+ 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