Excel macro template ...

This project received 26 bids from talented freelancers with an average bid price of $55 AUD.

Get free quotes for a project like this
Project Budget
Total Bids
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 :-

[url removed, login to view] 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.

[url removed, login to view] date each time i open the invoice template.

[url removed, login to view] 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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online