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)
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, Mai multe
14 freelanceri licitează în medie 32$ pentru acest proiect
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. Mai multe
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, Da Mai multe
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 al Mai multe
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 thi Mai multe
Hello, I'm interested in your project. I have a few questions about your project Please send me a message so that we can discuss more. Thanks
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 o Mai multe
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 Mai multe
hi, i would like to have great deal to fulfill your requirements in time and with perfect output as you expected. thank you
i have been working as an accountant dealing with the sales and purchase data,having practical experience to deal with such types of data.
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 Mai multe
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- Economi Mai multe