Hi,
As I understand you are looking for Excel add-in which can use values coming via ODBC connection and use them for summarization. It would help if you can share few samples of what kind of data comes in and how it needs to be added up.
Keen to work on this project.
Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation.
I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.
I would be happy to answer any queries that you may have.
Looking forward to working with you.
Thanks