Wednesday, January 30, 2008

Consolidate your data in your workbook with this addin

In may have sounded absurd 2 years ago. But as I continue to train others in my Advanced Excel Course, the idea has turned into a reality. It started off with using MSQuery to consolidate the data manually from different worksheets which I still offer as a topic for users to perform their consolidation and then to prepare reports using Pivot Table. Now, I have developed an add-in that could consolidate the data in seconds and start off with an empty pivot table so that users could prepare the reports based on their requirements. The Addin is free at this moment as I would like to collect some feedback on how to improve it further. So if you are keen, go to this page which will demo how to consolidate salary information for preparing income tax returns form. It will also tell you where to get the free download.

2 comments:

Unknown said...

Hi,

I have tried to download this Macro but received an error message from the Excel when trying to ad this macro in add in, I received that the file is not a valid add-in. I use Excel 2007, I would appreciate your help

thank you,

Michael

JK said...

Did you unzip the file?