Debra Dalgleish has a nice example of an order form at her website:
http://www.contextures.com/xlOrderForm01.html

Is that something you can work with?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel


"david" wrote in message
...
how do I make a order from a long list of items eg: a hardware stoe has a
long list of products but when making a order and I only select a few
items
how do you summarise onto 1 sheet?