Terminé

excel urgent work: create invoice file to meet my requirements

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

Compétences : Excel, Excel Macros, Excel VBA

en voir plus : create quickbooks invoice file visual basic, create xml file excel vba, can import excel invoice file quickbooks, contractor invoice template excel, free printable construction invoice template, professional contractor invoice, electrical contractor invoice template free, subcontractor invoice template, contractor invoice example, labor invoice template, labour contractor bill format in excel, create iif file excel, vbs excel create xml file, create csv file excel, excel vba create data file, work invoice file type pdf, create xml file excel, can quickbooks create invoice file, create dat file excel, excel 2003 vba create xml file

Concernant l'employeur :
( 385 commentaires ) Victoria, Canada

Nº du projet : #18962653

Décerné à:

ksriniravi

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, Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(165 Commentaires)
6.6

14 freelance font une offre moyenne de $32 pour ce travail

sajidkhan45

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. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(35 Commentaires)
5.1
chintuag

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
4.1
mehranica

I will do it in one day, see my reviews from other employers on my page.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
0.9
chraheelbhatti

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
0.6
ammaraunitech

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
amychou

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
HelenStuart

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
atul69030

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
niranjanninja

hi, i would like to have great deal to fulfill your requirements in time and with perfect output as you expected. thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
intesar123

i have been working as an accountant dealing with the sales and purchase data,having practical experience to deal with such types of data.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
PawelSwiegoda

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Enganas1989

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0