for all of you excel experts

[Guest]

i am working on a project where i am making a pricebook program. the user
will have many products to choose from and these products will be separated
into different categories. i need to be able to put the appropriate products
in a category into a listbox. the user will then be able to select the first
product they need, at which time the information for that product will appear
on the next line in 2 or 3 columns. after the user has selected all of the
products from that category that they need, they should be able to go down to
the next category and use the listbox for that category to do the exact same
thing and so on. the finished product of the pricebook after it is used
should look something like this:

product |quantity|unit price|cost
clothing: shirt 3 $4.00 $12.00
hat 1 $10.00 $10.00
sock 2 $1.50 $3.00
home: hammer 2 $3.50 $7.00
ladder 1 $20.50 $20.50
fun: video game 2 $5.00 $10.00
water gun 3 $.50 $1.50
tv 1 $50.00 $50.00
TOTAL: $104.00

It is important to note that these are only the products that this
particular user wanted. There are many other options that this user decided
not to get, and hence, they do not show up. Thank you for any help that you
may be able to give. It will be greatly appreciated, as i am getting nowhere

 

[David McRitchie]

Take a look at Debra Dalgleish's pages
Excel -- Data Validation -- Dependent Lists
http://www.contextures.com/xlDataVal02.html

I would fill in the Column A value, if you don't want to see
it you can use Conditional Formatting to change the text color to white
if value is equal to the cell above and the row above and the
current row have a QTY..


You could use VLOOKUP to fill in the unit price based on
the Column B value if they are unique among all categories
for instance I think apples would only be found in produce and
not clothing and not in home furnishings.