excel urgent work: create invoice file to meet my requirements
$10-20 USD
Terminado
Publicado hace alrededor de 5 años
$10-20 USD
Pagado a la entrega
i need a basic invoice template with following requirements:-
i have many styles. like style 1, style 2, style 3 etc. Each style has a fixed selling price. For example Style 1, selling price is $1, style 2, selling price is $3.5 etc.
So i need to be able to input all style numbers and their selling prices in one sheet.
Then in sheet 2, i need an invoice template, which can be saved by date, so for example if i create an invoice for 1st march, then i can save that invoice as 1st march in excel
In this invoice template if i enter the style numbers which exist in sheet 1, then their selling price should be shown automatically, so that i dont have to reenter it
I need following columns in Sheet 2(where i will create invoice)
date
style number (i will enter it manually, once entered check if exist in sheet 1)
style price (should come automatically if style number exist in sheet 1)
style quantity (i will enter it manually)
start weight (i will enter it manually)
end weight (i will enter it manually)
weight different (different between start and end weight)
total price (style quantity x style price)
then total invoice amount. then i should be able to save the invoice for future record.
Also note that i will contanstly be updating the style numbers, their cost, or adding new styles and their cost in sheet 1.
let me know if this is possible and if you can do this urgently
Greetings!
This is extremely straightforward. I can come up with a solution quickly in the time frame that you are expecting. I have only one question though.
If you have to have the feature to save the Invoice, then macro has to be included. Do you use Windows or MacOS? Some versions of Microsoft Office for Mac do not support Macros.
Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day.
I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month.
Have a Great Weekend!
Srinivasan Krishnamoorthi
$20 USD en 1 día
5,0 (165 comentarios)
6,6
6,6
14 freelancers están ofertando un promedio de $32 USD por este trabajo
Hi,
I am an excel VBA expert and have created many invoice and quote generator programs through VBA. You can check my profile and reviews on some of those jobs. I understood your project. The brief was impressive.
Can start right away
Hope to chat with you soon
Thanks
Sajid Khan
Dear Hiring Manager,
I have worked on many automation projects using excel macros and would like to work on yours.
My expertise include, but not limited to: Macros, Web Scraping, Forms, Dashboards, Pivot Tables, Data extraction from Access, PDF, Outlook, etc.
Looking forward to hear from you.
Regards
Chintu
Hy Sir, I am an expert in MS Excel both Advance Formula and VBA. I have read your description. I can do this. My product will give you many opportunity by using drop down and maximum automation to generate invoices also with auto invoice numbers. Let us discuss details in inbox. Thanks
Hello!
I am interested in your job.
Maybe there are freelancers that are bidding on this project.
You will select one of them that can provide you the good result you want.
They will say that they are expert in this field and I can also tell you so.
But I like the behavior than a word.
I will prove my skills with my work and if you give me a chance to work with you, I will do my best for the perfect result.
Hi Dear,
Having elevated the performance and profitability of diverse organizations through expert alignment of innovative marketing and advertising strategies, I am writing to offer your company more than 6 years of experience in creative development/leadership of promotional campaigns and creative marketing management. As a reputable and honored contributor to many top organizations, I am confident in my abilities to generate superior results for your company as Digital Marketing Manager.
Sincerely,
Lorene
Hello dear friend...
I'm interested in your project. I have no reviews to show you because I'm a new freelancer. Can I start my freelancer life with your project. I will be happy to do your work. I will not disappoint you. Let's get start chatting and discuss briefly.
Thank you.
Good day.
I have the skills to complete this project.
What you described is possible to do in Excel. I can do it urgently: if today you would choose me to do this work, I would provide you with a ready file no later than Monday early in the morning.
Greetings from Poland!
My Skills:
Expert in Matlab.
Expert in Microsoft office specially in excel.
Good in Multisim.
Arabic: Mother tongue.
English: Modest user (IELTS).
My Projects:
1- Short term Load forecast (Matlab).
2- Economic Dispatch (Excel).
3- Power system report (Excel).
4- PV solar panel connection grid (Matlab).
5- Optimal Power Flow (Matlab).
6- Solar Tracking System by PSO (Matlab).
7-Data Entry for different sector (Excel).