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.
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.
Last edited by ncmay; 01-29-2015 at 07:31 AM.
Reason: make correction
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By HelenClark in forum Excel Formulas & Functions
Last Post: 03-26-2014, 05:26 AM
By ghan7650 in forum Excel General
Last Post: 05-22-2012, 05:38 PM
By Wisconsinscw in forum Excel Formulas & Functions
Last Post: 06-08-2008, 07:05 PM
By GorillaBoze in forum Excel Charting & Pivots
Last Post: 08-25-2005, 04:05 AM
By Ed in forum Excel Programming / VBA / Macros
Last Post: 03-29-2005, 07:06 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1