+ Reply to Thread
Results 1 to 2 of 2

Two drop down boxes in the same line that populate info on that line.

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    Florida
    MS-Off Ver
    7
    Posts
    1

    Angry Two drop down boxes in the same line that populate info on that line.

    I hope i can say this so it is understood.
    I am creating a quote sheet with prices and descriptions from sheet2.
    The dropdown box I have will show the number and populate the description and price. Easy enough however I have a request for those that dont know the numbers want the description to be a drop down that populates the part number and price. There fore it will allow a search of either the part number and populate the line including the description, or vice cersa (search the description and populate the part number). I have attached the file I am working on minus the some specific info. Any help would be much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Two drop down boxes in the same line that populate info on that line.

    Try the attached workbook and see if it does what you want.
    It uses combo boxes instead of data validation.
    Attached Files Attached Files
    Last edited by ncmay; 01-29-2015 at 07:31 AM. Reason: make correction

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] X in colum A on worksheet 1 will populate different worksheet with line info
    By HelenClark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2014, 05:26 AM
  2. [SOLVED] Comparing two data sets that don't line up on a line to line basis
    By ghan7650 in forum Excel General
    Replies: 10
    Last Post: 05-22-2012, 05:38 PM
  3. lookup cell info and returning line info
    By Wisconsinscw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2008, 07:05 PM
  4. Drop line in Line Chart
    By GorillaBoze in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-25-2005, 04:05 AM
  5. [SOLVED] Macro problem on, Yellowed line - previous line or next line.
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2005, 07:06 PM

Tags for this Thread

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