I have over 2000 account numbers, each with it's own account balance.
However, I need to map some of these accounts together such that their
balance is consolidated. e.g. If i have 5 accounts viz 111,222,333,444,555
each carrying a balance of 2. I need to map these five accounts under a
category called 666 such that I can generate report that shows the balance in
666 as 10. I use excel 2003