Want to copy cells from one sheet to another using the check box.

[shadowpuck]

Warehouse Order List.xls
I'm attempting to set up an order sheet for work. On the first sheet are the items, codes, and prices. I've added check boxes next to each row. I'd like to be able to have users check the boxes they want to order, and have the first four cells (A-D) in that row copied onto the next worksheet.

[jmac1947]

I am having some difficulty in getting a macro to recognise tht the check box has been ticked.

Would it be just as acceptable if you altered col G to be the order quantity and therefore avoid having to manually update sheet 2??

In terms of sheet 2, is the number of lines always the same (and if so what happens if the user orders more item than will fit on the "page") or would it be simply acceptable to print only the order linas and total?

[shadowpuck]

Totally acceptable to alter col G - I took out the check boxes and changed it to Quantity Ordered (Warehouse Order List #2.xls). So now, after a user goes down the sheet and enters quantities in Col G, I'd like to have a button at the bottom that runs a macro that takes the lines that have orders and copies/inserts them to the order sheet. The number of lines on sheet two isn't always the same, and it wouldn't matter if it exceeded one page.