Excel macro template ...


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: Data Entry, Excel, Visual Basic

See more: vat excel template, invoice macro excel template, excel macro save invoice name, ready invoice template macro, rest specification, labor ready, i need data entry done today, fao, excel specification, customer data excel template, ask excel, invoice template in excel, excel invoice template , customer data in excel, opening sequence, excel work today, excel calculation, insert macro excel, contact excel sheet, excel base data, etc excel template, sheet excel visual basic, 2013 excel visual basic, excel 2013 visual, excel 2013 macro

About the Employer:
( 11 reviews ) LONDON, United Kingdom

Project ID: #4530802

26 freelancers are bidding on average $55 for this job


Mate, Excel VBA expert here. Please check PM for details. Thanks!

$40 AUD in 2 days
(66 Reviews)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$40 AUD in 2 days
(59 Reviews)

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$35 AUD in 2 days
(42 Reviews)

Consider it done. Check your PM for my bid details.

$30 AUD in 1 day
(52 Reviews)

See PMB please.

$35 AUD in 1 day
(51 Reviews)

Dear Dr. Mohamad, i can do it with VBA easily. The workflow would be as following: You have a macro enabled excel file with all your customers data (list of existing customers). when you call a macro addNewInvoice (fo More

$40 AUD in 5 days
(28 Reviews)

can provide you better solution to what your requirement is

$111 AUD in 3 days
(11 Reviews)

I am a native English speaker with extensive experience in developing custom Excel/VBA applications, as well as excellent ratings on the projects I have done. I can do your template project.

$166 AUD in 10 days
(15 Reviews)

Hi MAcro Expert Here. I went through the requirement looks very simple. I can complete this in few hours

$40 AUD in 2 days
(31 Reviews)

Expert Here.. .Please check PM...

$50 AUD in 3 days
(20 Reviews)

Hello I am an Excel VBA developer with many similiar such projects completed. I can quickly and easily set up an Excel workbook based on your invoice template with the associated macros to roll over the Invoice dat More

$35 AUD in 3 days
(16 Reviews)

Sending you a sample Excel 2010 sheet that does exactly what you want. You can have complete file as soon as you pay fee into site. More details on Private Message Board. Bob Allen-Turl

$40 AUD in 1 day
(2 Reviews)

HI, Excel VBA expert here, plz chk pm for DEMO. Regards

$30 AUD in 2 days
(8 Reviews)

Greetings, DrMohamad... I am an expert in Excel Macros and VBA... Please, refer to my profile for projects and feel free to communicate with me through this private massage... You will get your requested template withi More

$55 AUD in 1 day
(3 Reviews)

ready to work now

$40 AUD in 3 days
(5 Reviews)

Please check pm.

$30 AUD in 5 days
(1 Review)

i have experience with your project,, please check pm

$244 AUD in 4 days
(0 Reviews)

excel user for 10 years and vba expert here, i can do this job.

$35 AUD in 4 days
(0 Reviews)

Ready to deliver within one day

$30 AUD in 3 days
(0 Reviews)

I can do this job, Please check the PM

$35 AUD in 7 days
(0 Reviews)