Order Form to Summarise Order on another sheet with a Submit Order Button

I need to create an order form that has the function to click on the Submit Order button and it will only take the products ordered into an order Summary form so I can print and fax only the products I am ordering and not the whole list.
Any product being ordered is highlighted as per the sample sheet and they are the only items that should be taken across to the Order Summary Sheet.

Help Please


Stock Price List.xlsm

Hello KazzICC,

I think the attached may help you out.


KazzICC.xlsm

Column A is the active column so all you need do is click on the product code for each item you wish to transfer to highlight the cell and then click on the submit button. The data should then transfer to the "Summary" sheet.
Did you want to delete each row of data from the Stock sheet once transferred to the Summary sheet? This would prevent duplication and clutter.

Cheers,
vcoolio.

Thanks for that, it is very close but I need something that a user can select all the product quantities they want to order and when they click on the submit order button it picks everything up that has a number in the quantity box and takes all of the products into the order summary sheet.
Is that possible?
Then they do not save their changes and when the next person uses the sheet it is blank again and ready to use.

Hello Kazz,

Now I understand what you want. You wish to make a number of entries in the Stock sheet and when that is done, transfer all entries as a group to the Order Summary sheet, correct?

If so, I think the attached may be what you want.

Cheers,
vcoolio.

Thank you so much that is perfect

Hello Kazz,


Glad that I was able to help.

Cheers,
vcoolio.