Purchase Order System - VBA for new worksheet from template with PO number auto generated

[ooos9272]

I am part way through creating a Purchase Order system.

I have so far:
- One workbook
- First worksheet 'Suppliers' is a list of suppliers with all supplier data
- Second worksheet 'Template' is the PO template which uses Data Validate to choose supplier details from a drop down list.

I want to:
- Be able to create a new PO (i.e. create a new worksheet) from the 'Template' via a macro button which will be place on the 'Supplier' worksheet
- Have the date auto fill when the new PO (i.e. new worksheet from 'Template') is created
- Have a new PO number auto-create when a new PO is created (ideally the PO number will begin with the supplier initials e.g. Bunnings PO's will be BUN01, BUN02, BUN03)
- Have a macro button that will automatically save out / open the new PO as a PDF

I have some macro experience but really need some help with this task.

Much appreciated, ooos9272

[humdingaling]

maybe this may help you
http://www.excelforum.com/excel-gene...em-wanted.html