Summary of 2 sheets based on Date and Ind ID#

**koklok** · 05-07-2009, 01:18 PM

Attachment is included

I need a macro that will pull the amounts from Credit sheet (by date by Ind ID) and then subtract amount from Debit sheet(by date and by Ind ID) and give me a summary in the summary sheet.

Please look at the "Should look like this" sheet to see an example.

Please make the macro as simple as possible, or explain the steps

Thanks

Sorry... The sheet "Should look like this" doesn't have correct numbers, but the format should look like that...

**Charles** · 05-09-2009, 04:50 PM

Hi,

See attached workbook.
I coded to what you have. You will need to add more headers to the summary sheet so the it will match the "Headers" that you have listed in column "F" of the Credit/Debit sheet.
For the most part this should work. In this attachment I did not do a lot of code work for errors, this should get you started.

**koklok** · 05-12-2009, 05:13 PM

Charles this is not working
Amounts are not being added correctly (honestly sum by date and Ind ID doesn't make sense)
Dates that don't have any amounts in debits and credits sheets, have summary amounts in Summary sheet.
I really don't know what needs to be fixed but numbers don't add up

**Charles** · 05-12-2009, 06:43 PM

Hi,

Did you finish putting all of the headers in the "Summary" sheet?
If not this may be why the totals are not working. I only tested
The total for "Dates" 4/27/09" and IND ID NO=0939, IND ID NO=0939,
IND ID NO=0969. For Credit and Debit appeared to work for me.
What I did was set up 2 filters 1 was for the Date and the other was for the items in column "F". when the filter is set I looked at column "D" for the amount and Summed the data and put it in the "Summary" sheet.