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

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.

Taidot: Excel, Visual Basic, Visual Basic for Apps, Excel Macros, Excel VBA

Näytä lisää: sample code generate fake data, vba code generate report excel, excel vba code data web page, generate graph code excel vba, excel vba tutorial generate report, vba code appliaction update data excel, excel vba code pull internet data, excel vba chart click show data, excel vba example read cvs data, vba code import project data excel, excel vba download yahoo financial data, excel vba macro copy columns data, excel vba code download historical data yahoo, excel vba button to load data from csv, excel vba userform to input data, how to make excel vba executable, excel vba get chart source data range, excel vba loop to find records matching search criteria, excel vba get value from data validation list

Tietoa työnantajasta:
( 0 arvostelua ) Ernakulam, India

Projektin tunnus: #29378075

16 freelanceria on tarjonnut keskimäärin ₹1077 tähän työhön


Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at I checked the sample input and output that you provided and the attached Lisää

₹1199 INR 1 päivässä
(154 arvostelua)
(107 arvostelua)

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 Lisää

₹1000 INR 1 päivässä
(42 arvostelua)

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 portfoli Lisää

₹1500 INR 2 päivässä
(29 arvostelua)

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

₹1500 INR 1 päivässä
(31 arvostelua)

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

₹2000 INR 1 päivässä
(31 arvostelua)

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 sta Lisää

₹1000 INR 2 päivässä
(16 arvostelua)

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 päivässä
(7 arvostelua)
(2 arvostelua)

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 päivässä
(0 arvostelua)

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 päivässä
(1 arvostelu)

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.

₹1200 INR 3 päivässä
(0 arvostelua)

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.

₹1050 INR 2 päivässä
(0 arvostelua)

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 päivässä
(0 arvostelua)

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 päivässä
(0 arvostelua)

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 Lisää

₹800 INR 1 päivässä
(0 arvostelua)