Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BLW" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |