Kapalı

Excel VBA macro for prepare invoices automatically from a sale orders table

I am looking for Excel VBA code, to import specific information from "SaleOrders" Sheet to the "Invoice" sheet (please find the excel file here [url removed, login to view] )

The information to be import, will depend on cell B11 ("Invoice" sheet). Depending on this value, the macro should find all the rows in "saleOrders" sheet that meet the criteria (according to column B) and import the data in sheet "Invoice" in range A16:H24. Please note we are not importing the entire row, only some cells.

Additionally, we need to hide rows in range 16:24, which do not have any content.

The macro should generate one new excel file and one new pdf file for each new different invoice number.

Furthermore the invoice number must evolve in a consecutive way and when the invoice has been saved as pdf and xls, all the data will be send to a specific file containing a registry of all issued invoices.

Beceriler: Veri İşleme, Excel, PHP, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: save invoice data in excel, excel vba save invoice data, excel vba invoice generator, how to create automated invoice in excel, excel vba invoice template, how to save invoice in excel, transfer data from invoice to worksheet automatically with vba, invoice generator excel automation, excel vba macro copy columns data, download historical stock data excel vba macro, excel vba macro scripter, running excel vba macro sql server, excel vba send outlook mail automatically, excel vba macro charts, excel vba macro protect cell

İşveren Hakkında:
( 0 değerlendirme ) Spain

Proje NO: #15694531

Bu iş için 55 freelancer ortalamada €342 teklif veriyor

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(570 Değerlendirme)
8.2
schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience in D Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(249 Değerlendirme)
7.4
seaanddream

Hi, my name is Sevinc. I read your "Excel VBA macro for prepare invoices automatically from a sale orders table" project descriptions carefully before bidding. I checked the attached excel template as well... I got w Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(264 Değerlendirme)
7.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(268 Değerlendirme)
7.7
aarifakhtar

Hi: I understand that you want to use the data from SaleOrders" sheet to generate invoice. The macro will take the input on B11 cell and find all orders related to that invoice and generate invoice Relevant Skills and Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(164 Değerlendirme)
7.0
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(297 Değerlendirme)
7.2
DigiWhizz

Hey, I am James, your php project caught my eye and would love the opportunity to discuss further with you to see if we are a fit... Relevant Skills and Experience: Expert in Data Processing, Excel, PHP, Visual Basic, Daha Fazla

in %bids___i_period_sub_35% gün içinde530%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)
7.5
ksriniravi

Greetings! I understand all your requirements and can develop an automated Invoicing Solution that generated XLS and PDF invoices while logging them as well. Relevant Skills and Experience 18 years experience in using Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(144 Değerlendirme)
6.6
paris2785

Hello. My name's Paris. I can develop the macro to retrieve data from "saleOrders" sheet to fill the invoice in "Invoice" sheet. The new invoice with a new number and will be saved as .pdf. Relevant Skills and Experie Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(137 Değerlendirme)
6.6
NallakumarKC

We can put a button in the Sales Order sheet and upon clicking that button, we make the invoice generation process automatically. To make it as PDF, we need to install a free third party module. Relevant Skills and Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
6.3
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy Relevant Skills and Experience ex Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(252 Değerlendirme)
6.5
avinav606lx

Hi there, This looks feasible and I have written many scripts. I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(157 Değerlendirme)
6.5
mail2vimalarora

Hi.. I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on several excel macro/vba projects and based on it I can design the same following your r Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(80 Değerlendirme)
5.8
zu02

Hi, I can code that faster using sql/ado vba within your Excel xlsm sheet. Regards, Zura Relevant Skills and Experience ms Access/Excel/VB programmer since Ms Office 97 released Proposed Milestones €250 EUR - default

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)
5.8
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. Relevant Skills and Experience I have a lot of practical experience in Excel, including programming in VBA. [url removed, login to view] Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)
5.4
osmemon

I have 7 years of experience in Excel and VBA Macros. I can deliver the complete order tracking macro to new Excel and PDF with in 1 day. See my profile for client reviews to judge me efficiency. Relevant Skills and E Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)
5.6
prabakarm23

I can help you with this project to make it successfully completed with my experience Relevant Skills and Experience worked on VBA, VB and .NET for almost 7 years with applications like SAP ,IE, PDF, MS Access and SQL Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(60 Değerlendirme)
5.1
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
5.1
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project! As you can see in my reviews I have a lot of experience with excel and vba, I also speak spanish. Habilidades y experiencia rel Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(77 Değerlendirme)
5.0
vsprybhanu

Hi, I have read your instructions carefully and saw attached file. I can extract data from SaleOrders sheet according to condition and put into Invoice sheet in specific format. Relevant Skills and Experience I can co Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)
5.3