• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding amounts at date intervals

O

OAhmed

New Member
Hi,

I have a bank statement and want to total the entries, debits and credits in separate columns, for each day. I am not good at macros, so please help with simple tricks.


Thanks in advance.
 
Hi OAhmed,


Welcome to Chandoo.org!!


Pls mention some sample entries to get your solution more accurate and faster.


With given information, the solution would be to use the inbuilt function of excel "SubTotal".


Select your range of data and goto Data Tab (Ribbon) > click Subtotal > select on change of date (Column) and Sum of Debits and Credits (Columns).


Regards,

Prasad DN
 
Hi OAhmed,


Welcome to the forum, take a look at these links, they may help?


http://chandoo.org/wp/2009/11/23/household-budget-spreadsheets/


http://chandoo.org/wp/2010/07/16/download-expense-trackers/
 
Hi OAhmed,


Welcome to the forum, take a look at these couple of links, they may help?


http://chandoo.org/wp/2009/11/23/household-budget-spreadsheets/


http://chandoo.org/wp/2010/07/16/download-expense-trackers/
 
You must log in or register to reply here.
Back
Top