yet another exciting Excel question about lists

If I was doing this all in Access, I prmoise I wouldn't be bugging you so much! (unfortunately I'm the only one who has access, and this has to be shared with others)

Okay, I have a sheet with two columns. One lists the product name and the other lists the product price. (That's easy)

On another sheet, I'd like to be able to create a lookup for this list. This is how I'd like it to happen. Someone tell me if I'm off my nut and it can't be done this way!

Sheet 1: Contains the product list described above.

Sheet 2: Contains a generic form that, say, a salesperson is filling out. It contains a checkbox selection so that the person can just check off all the products that a customer would be buying.

Sheet 3: Here's the tricky part. I want all of the selections to list on this sheet, along with their prices. Now, I know how to use Vlookup to get the price showing up once the product is there. My two problems are:

(A) How do I get the products that are checked off to list on Sheet 3.
(B) Is it possible to confine X amount of products per sheet? I mean, if a salesperson checks off 52 products, and I know only 20 will print per page, can I ensure that only 20 checked off products will go to Sheet 3, 20 to Sheet 4, and 12 to Sheet 5?

Am I totally confusing everyone yet?

Thanks for giving any sanity check you can!!!!!

 

Save yourself some grief. Develop your Access app then push out a runtime version to the others.

http://www.poplarware.com/accessruntime.html