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.
Subscribe to:
Post Comments (Atom)
2 comments:
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
Did you unzip the file?
Post a Comment