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 a

(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?