Develop reusable VBA Macros for my MS Excel Reports.

I want to automate 2 reports via VBA Macros as follows


A monthly sales report. My Report has the following fields (See attached).

My interest is for you to develop a VBA macros script which will automatically on running the script generate the following reports (See attachment)

(1) Sales Revenue Analysis by Centre showing amount paid and amount unpaid orders (2) Sales Count Analysis by Centre showing count of paid and unpaid orders (3) Analysis of Discounts (4) Top 10 customers by revenue and by orders (5) List of customers with unpaid orders (6) List of discounted orders or customers


I want to validate or confirm the truth for orders indicated as paid in the sales report by looking up a bank statement/reconciliation record and pulling up the date and amount paid in the bank statement into a field on the sales report. Each payment record would be set off against the order amount and it there is a difference it will indicate so. It will also allow for manual intervention for some records.

This is an urgent which i need within a day or 2. Its also one I consider a simple job which I expect would cost low.

I would share all the files with selected freelancer under professional NDA.

Compétences : Traitement de Données, Excel, Architecture Logicielle, Visual Basic, Visual Basic pour les apps

en voir plus : writing vba macros excel 2007, vba macros excel issue incremental number, vba macros excel increment number, excel, display data values excel chart using vba macros, excel reports samples vba, vba macros excel, excel vba import ms project, excel vba macros, excel vba macros work mac, monthly sales report excel graph, read text file save unicode file excel vba macros, vba macros excel attach, vba macros excel hot lines count, vba macros excel jobs, qtp vba macros excel create test data, monthly sales report excel, excel reports vba, excel vba macros experts, vba macros optimization excel database

Concernant l'employeur :
( 25 commentaires ) LEKKI - AJAH, Nigeria

Nº du projet : #17522692

Décerné à:


Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 4 jours
(46 Commentaires)

11 freelance font une offre moyenne de $60 pour ce travail


Hello, I can help with you in your project Develop reusable VBA Macros for my MS Excel Reports. I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(278 Commentaires)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(72 Commentaires)

Hi, I have read very carefully your project details about writing VBA Macros that will automate Monthly sales report analysis and automate revenue assurance Excel. I am absolutely sure that I can complete this project Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)

Hi, I am an expert in excel vba, macro. I have many experiences in data processing using excel. I can help you with high quality. Thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)

Hello. I am expert in Excel macro and I can help you. I can give you perfect result today. We can have a more discussion on your project. Regards.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)

Hi Sir I am a new freelancer. I am willing to do this project at minimal cost or even for free as I am only looking to get positive feedback. Regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)

Hello, I read your job description and I possess all the necessary skill for this work. I have 16 Years of Experience in Excel VBA. I can complete your project in 1 day. Thanks and Regards Sounak.

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

Excellent in excel, Microsoft office, certified Six sigma, Expert level analytical skills, .Good experience in same, also have good knowledge of Macros.

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

I am Good at this kind of work.

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