Excel macro template ...

CLOSED
Bids
26
Avg Bid (AUD)
$55
Project Budget (AUD)
$30 - $40

Project Description:
I want to open the template.
Insert parts and labor
Save as "New Name"
Then work on new customer by opening orginal template (invoices # increases by one)
Insert parts and labor
Save as "New Name1"
Then work on another customer by opening orginal template and the template invoice number increase by 1.

This scenerio would give me three customers invoices with three different invoice numbers and the template ready to be opened with a the fourth number in sequence.

More specification :-

1.on template of an invoice (in excel) , I need it to automatically
generate a different invoice number every time I open it. Such as 001 the

1st time, 002 the 2nd time etc.
and when saved the generated invoice then the invoice number is updated.
or example i open the template and says invoice number 3 - i make my invoice wants to save it when i save it it should ask me do you want to upgrade the invoice number and i say yes so the next time i open the template then the invoice number should be 4. but remember i don't want the number to change when i am opening the invoices saved , once they are saved that's it done have nothing to do with the template.


2.today date each time i open the invoice template.

3.customer date base so i can just select and the detail and contact number and reference and FAO to come up and fill the requirement.

4. the calculation of VAT and the rest as it shows.

5.i want another sheet to have invoice summary so when the invoice created automatically saved in there. i need to filter them according to quarter of the year basis , means Jan 13 to march 13 as one ,,,, April-13 to Jun 13 as 2. ......

i have attached something for your assistant but i don't want anything as complicated as that.

Skills required:
Data Entry, Excel, Visual Basic
Additional Files: Online-PC-Learning-Invoice-Generator-1.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire bharanisrihari
$ 40
in 2 days
$ 40
in 2 days
$ 35
in 2 days
$ 30
in 1 days
Hire northwolves
$ 35
in 1 days
$ 40
in 5 days
$ 111
in 3 days
$ 166
in 10 days
Hire rengrish
$ 40
in 2 days
Hire microk
$ 50
in 3 days