My suggestion is that Macros would not be required for this project. To do anything like this and make it truly automated, you'd need a list of the IDs that show up in your statement and associated categories... then you could import or past in your financial data into a predefined range. Your formulas would then convert that data give you whatever 'business intelligence' you desire. You could set up a pivot chart or pivot tables based on the range of data in those formulas to give you a set of data that is easier to work with.

1. Initial data -> 2. formulas to convert (based on lookups and categories) 3. -> Pivots and or Pivot Charts for Presentation.

Good Luck!

-Brian
www.excel-help.net