I was hoping I might draw on the expertise of the forum's users for assistance on a macro. I receive raw trial balance data in an excel file (see raw data tab in attached workbook). I want to sum the amounts in column D, by the financial statement line mapping in column E onto the Cons TB tab (column B) for only comp code 926 (listed in column A).
If someone can provide this macro then I could duplicate it for the other company codes which will be listed on separate worksheets identical to the Cons TB tab.
I only included several lines of the raw data dump, however, my file is typically 6,000 lines and the conditional sum arrays I am using really bog the file down when it recalculates.
I'll appreciate any assistance provided.
Thanks,
Bookmarks