Macro to create a 'Create Order' button which pulls data onto another sheet

[NicNac123]

Hi all.

I have the below headers in a spreadsheet with product data underneath. I have entered quantities of 10 and 15 against items 2 and 3 because I want to order those items and I've left the other quantities blank.
I then want to have a 'Create Order' button within the spreadsheet which, when pressed, pulls the data from the 10 and 15 qty lines into another worksheet creating an order form for the items required only.

I am then looking to have a button on the order form sheet which, when pressed, will attach the worksheet to an email as a PDF.

Hopefully I have explained well enough what I want to do and someone can please help.

Many thanks.
Nicola

 

[dmt32]

Hi,
Have a look at this file here:https://www.contextures.com/ProductsListOrder.zip
It's a free site and sample workbook may help you in development of first part of your project requirement.

Once have that part resolved, can then move to next stage to email document.

Dave