Email Data Consolidation Tool
Power Pivot VBA

Email Data Consolidation Tool in Excel

In this article, we have created data consolidation tool to consolidate the data from multiple emails. We have create the excel template also for sales data. Multiple salesman can fill this sales template and send it using Send on Email button in Sales Template. Email will come to a specific outlook folder. We have used outlook rule to move the email on the base of specific word in subject line. This consolidation tool will download the attachments from those emails and will consolidate in to one Excel sheet.

Below is the Excel Template:

Sales Template
Sales Template

Below is the Data consolidation Tool:

Data consolidation Tool
Data consolidation Tool

Below is the Consolidated Data:

Consolidated Data
Consolidated Data

Watch the step by step video tutorial:

Click here to download the practice file.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com