Make me an Excel VBA Code to generate consolidated data according to certain criteria

₹600-1500 INR

クローズ

投稿日:

約3年前

₹600-1500 INR

完了時にお支払い

I have an Excel Sheet with details of orders made by customers and corresponding supplier data. It has a lot of columns, but I will be discussing only the relevant ones. There are MainBuyers under which Sub Buyers operate. The excel entries give details of the name of the outlet, name of main buyer to whom the outlet belongs to and item details(quantity, amount etc.) The requirement is to create a VBA Macro code that will automatically add up all the quantities for a particular Item when i select a MainBuyers name and generates a consolidated report.(as shown in image) Please note that Main Buyer can directly place order without a SubBuyer. In that case the Outlet Name Field will be blank.

Excel

Visual Basic

Visual Basic for Apps

Excel Macros

Excel VBA

プロジェクト ID: 29378075

プロジェクトについて

16個の提案

リモートプロジェクト

アクティブ 3年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

この仕事に16人のフリーランサーが、平均₹1,077 INRで入札しています

@sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I checked the sample input and output that you provided and the attached excel file. I can provide you with a VBA macro for generating those totals as you mentioned but I think what you are trying to achieve can also be done using built in pivot tables. I will be happy to share with you a sample of that too if that might work better for you. I assure the best in class services and fairest prices. Do consider me once, won't disappoint you. Would wait for a positive and prompt response from your side :) Best Sourabh

₹1,199 INR 1日以内

5.0

(154 レビュー)

6.2

@dhanrajkarthick

Hi there, Gone through your requirements and sample images too. I clearly understand what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Kindly go through my profile. Awaiting for your response. Regards, Karthick G.

₹1,000 INR 1日以内

5.0

(42 レビュー)

5.2

@swarnali2017

Hi, I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see in portfolio) that main goals were to capture information from websites. I can start now. Therefore, I would like to discuss with you about the project details. Looking forward to hearing from you! Thanks in advance. Best Regards, Swarnali

₹1,500 INR 2日以内

5.0

(29 レビュー)

5.4

@IgeS

Hi there, Need a VBA code that will summarize the data in "base" tab into "required output" tab. Please contact me if this is any of what you need. I'll be standing by to help. -Ige

₹1,500 INR 1日以内

5.0

(31 レビュー)

5.1

@yadavexpert53

AVAILABLE - ALMOST DONE SURE SIR, I CAN FINISH THIS TASK "Make me an Excel VBA Code to generate consolidated data according to certain criteria" QUICKLY. YOU CAN MSG ME ANGET YOUR PROJECT. THANKS

₹2,000 INR 1日以内

4.9

(31 レビュー)

4.6

@ShivaniGoyalsai

Hi, I have 10+ years of experience in VBA programming and database management. I checked the requirement and as an expert i can complete the project most efficiently. if interested we can connect via chat and get started. Thanks Shivani

₹1,000 INR 2日以内

4.5

(16 レビュー)

3.8

@rangav12891

hi , I am expert in excel automation . I have 7+ years experience in macros. I have delivered all the projects on time with good quality.. please feel free to contact me

₹600 INR 1日以内

5.0

(7 レビュー)

2.9

@GN0202

To work in a creative and challenging environment using all my knowledge and skills where I could constantly learn and successfully deliver solutions to problems, which helps in the organization growth.

₹777 INR 7日以内

0.0

(0 レビュー)

0.0

@jiansevillejo

Hi, I'm interested on this post. I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I can help you finish this work as soon as possible.

₹750 INR 1日以内

5.0

(1 レビュー)

0.0

@sjmohammed90

Dear Sir, I have read your project description. I am much confidence about my skill to do the job done with in a quick deadline give me a chance.

₹1,200 INR 3日以内

0.0

(0 レビュー)

0.0

@anandupadhyay16

I am have done MCA and work as freelancer as well Deputy manager in Kunstocom india Limited. I have professional team to handle any problem. we will complete your project with in two days.

₹1,050 INR 2日以内

0.0

(0 レビュー)

0.0

@abhishekglv

Hello client, I usually do excel based project which includes VBA macros, automation etc. I think i can do this work also with lesser time. Thanking You

₹600 INR 7日以内

0.0

(0 レビュー)

0.0

@apurcamistry2

I have completed similar kind of macros for calculation width of pipe rack for each tier. In thatvi have to short pipes and tray from the 3D REPORT.

₹750 INR 1日以内

0.0

(0 レビュー)

0.0

@rohitrameshsri

Hi Client, I have checked the sample input and output which you have provided and completed your task which is ready to be delivered, the only thing which is left is your approval. I will be happy to take this up and assure the best service at the fairest price. Would wait for a positive and prompt response from your side. Thanks, Rohit

₹800 INR 1日以内