Hi,
is there a code or can someone point me in the right direction? i have a
workbook with invoices and i need it to do the following:
1. press a button and it will copy a template and place it at the end of all
other sheets naming it in invoice numerical order ( 1234,1235,1236 etc)
2. create a link to a front page to transfer basic information ( i can do
this )
3. export the active sheet to be an independent sheet on its own in a
specific location like ( s:\invoicing\yearly invoices\month )
i have a folder in this location with sub folders ranging from April to
September 06

I am ok with code and underatand it however i just cannot seem to work out
how to do this.


help appreciated

N.S.