I’m looking for a formula or macro that is probably a combination of a Subtotal and VLookup. I don’t know much about macros – someone has written me a Macro in the past, which I can add to my sheet – but I don’t really know how to write a real Macro. I have one tab of data, arranged as follows:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
Column A Column B Column C Column D<o></o>
Date (N/A) Account Amount<o></o>
<o> </o>
For my export data, I want each transaction to be put into the proper row/column, based on the date and account listed for that amount. Row 1 will show a list of the Accounts across the top, and column A will have a list of dates along the left. For each transaction (line item) in my raw data, I want it to put the “Amount” (found in Column D of the raw data) to be put into the correct row (based on the “Account” found in Column C of the raw data) and the correct column (based on the “Date” found in Column A of the raw data). For a given date/account combination, there is usually one transaction listed – but there can be zero, or there can be multiple amounts lists. Therefore, the export should have the total listed for all transactions for that given date/account combination. <o></o>
<o> </o>
Any help would be greatly appreciated. As I said, I don’t know how to write a macro, but I can paste it into my excel file if needed. If this can be accomplished with a formula (some sort of long combination of Subtotal and VLookup, or other formulas), just let me know how. <o></o>
fficeffice" /><o></o><o
> </o>Column A Column B Column C Column D<o
></o>Date (N/A) Account Amount<o
></o><o
> </o>For my export data, I want each transaction to be put into the proper row/column, based on the date and account listed for that amount. Row 1 will show a list of the Accounts across the top, and column A will have a list of dates along the left. For each transaction (line item) in my raw data, I want it to put the “Amount” (found in Column D of the raw data) to be put into the correct row (based on the “Account” found in Column C of the raw data) and the correct column (based on the “Date” found in Column A of the raw data). For a given date/account combination, there is usually one transaction listed – but there can be zero, or there can be multiple amounts lists. Therefore, the export should have the total listed for all transactions for that given date/account combination. <o
></o><o
> </o>Any help would be greatly appreciated. As I said, I don’t know how to write a macro, but I can paste it into my excel file if needed. If this can be accomplished with a formula (some sort of long combination of Subtotal and VLookup, or other formulas), just let me know how. <o
></o>
