Excel 2007 : Copying selected values to another Excel sheet

[woody60]

I wonder if the following is doable?

I enclose a copy of my Purchase Order template.
What I would like to do is to copy the data circled in red (I've put the cell references alongside them), and paste them in the next available row on Sheet 2, so I have a record of what has been ordered.

Is it also possible to save the Order automatically as a PDF using Supplier name, Customer name and order number as the file name?

Purchase Order Template1.jpg

[jraj1106]

Hi

Upload the template...

[woody60]

OK - here we go
Purchase Order Template.xlsx

[rvasquez]

See below post. I updated your workbook instead to make it a little easer for you.

[rvasquez]

Hello There,

Attached is your workbook updated to include a command button that when clicked runs a macro that I believe achieves everything you were wanting.

Let me know if you have any questions.

Thanks,

RVASQUEZ

[woody60]

That is absolutely BRILLIANT!
I see I had to change the save location for the PDf and then it worked a treat.
I can't thank you enough.

[rvasquez]

No problem! Glad I could help! Don't forget to mark this post solved. Thanks!