Home |
Search |
Today's Posts |
#1
|
|||
|
|||
for all of you excel experts
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |