Hi everyone,
I have been trying to sort this out myself but with no luck.
I have 2 worksheets, 1 is called "Club Ledger" the other is called "Financial Summary"
Worksheet "Club Ledger" has 4 columns, Column "A" is the Date, Column "B" is Description, Column "C" is Credits & column "D" is Debits, Columns "C" & "D" are dollar values.
Column "B" can have entrys like: Member Fees, Recycling, Raffles ect, these can appear many times during the course of the year.
Worksheet "Financial Summary" has 3 columns, Column "D" has Description IE: Members Fees ect, Columns "E" & "F" are dollar values, at present i add all the items manually from the "Club Ledger" worksheet as you can imagine this is very time consuming. then put those total values into the "Financial Summary" worksheet.
Is there a way using VBA to match all entrys in the "Club Ledger" worksheet say "Members Fees" or "Recycling" then look at column "C" which holds the dollar values and sum all of those matching values to Column "E" or "F" of the "Financial Summary" worksheet.
here is the tricky part, "Financial Summary" worksheet has 5 rows starting at row 7 and going to row 11, each one has either Members Fees or Recycling ect in it and these are for Income only.
Rows 15 to 20 are for Expenses only so they can have Stationary, Shopping, Party Supplies, Petty Cash ect.
so the vba needs to search for the matching entrys then sum all the entrys that match that entry.
I hope this is easy to understand.
Thanks in advance for any help.
I have been trying to sort this out myself but with no luck.
I have 2 worksheets, 1 is called "Club Ledger" the other is called "Financial Summary"
Worksheet "Club Ledger" has 4 columns, Column "A" is the Date, Column "B" is Description, Column "C" is Credits & column "D" is Debits, Columns "C" & "D" are dollar values.
Column "B" can have entrys like: Member Fees, Recycling, Raffles ect, these can appear many times during the course of the year.
Worksheet "Financial Summary" has 3 columns, Column "D" has Description IE: Members Fees ect, Columns "E" & "F" are dollar values, at present i add all the items manually from the "Club Ledger" worksheet as you can imagine this is very time consuming. then put those total values into the "Financial Summary" worksheet.
Is there a way using VBA to match all entrys in the "Club Ledger" worksheet say "Members Fees" or "Recycling" then look at column "C" which holds the dollar values and sum all of those matching values to Column "E" or "F" of the "Financial Summary" worksheet.
here is the tricky part, "Financial Summary" worksheet has 5 rows starting at row 7 and going to row 11, each one has either Members Fees or Recycling ect in it and these are for Income only.
Rows 15 to 20 are for Expenses only so they can have Stationary, Shopping, Party Supplies, Petty Cash ect.
so the vba needs to search for the matching entrys then sum all the entrys that match that entry.
I hope this is easy to understand.
Thanks in advance for any help.