Results 1 to 10 of 10

Excel 2007 : Getting price to autofill after picking product from dropdown list

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Getting price to autofill after picking product from dropdown list

    Hi everyone, I am new to the forum and excel so first off, I wanted to apologize for any errors that may occur.
    I am trying to get a price to show up in cell after picking product from dropdown list. The product and price table are in another sheet and are seperated product price - product price, and I don´t know VBA at all if that is necessary.

    The example of the Invoice sheet1 product table sheet2:

    Sheet1
    A------------------------------------------B-----------------------------------------------------------C
    Product Tipe--------------------------Product--------------------------------------------------------Price
    Diverse----------------------------------Washer--------------------------------------------------------0,30


    Sheet2
    A-----------B---------------C------------D----------------E--------------F----------G----------------H
    Diverse----Price--------Steel-------Price-----------Aluminum--------price-------Nickel-------------Price
    washer---------0,30---------1/2--------2.00------------1/4 pipe---------7.00--------sheet-------------2.00

    Hope someone can help.

    Thanks
    Last edited by Luis Honorato; 02-11-2012 at 07:13 AM.

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