Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BLW
 
Posts: n/a
Default CAN ANYONE PLEASE HELP ME????

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 description 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.
  #2   Report Post  
BLW
 
Posts: n/a
Default

that graph didn't come out so good. this should be a little better:
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

"BLW" wrote:

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 description 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"