Add Monthly direct debits

[ijburnell]

I keep a simple Spreadsheet to track my bank activities. Date, Details, Debit, Credit and running balance

I'd like to automate each months Direct debits. I can put them into a separate sheet e.g. 1st month Council tax amount £100 for example

At the start of a new month I'd like to run a macro or something to simply copy the Direct Debits from the sheet into the current month with the correct date format - so in the above example it would have for month December 2021 - 1/12/21 Council Tax Debit £100

Any advice please?

[JohnTopley]

See attached as a (well-tried) pro-forma> Monthly sheets incorporate all SO/DDs plus Credit card transactions. Macro used to reconcile with downloaded bank statement.

[johns_123]

can someone elaborate this question i am facing the same problem and looking for the solution

[Glenn Kennedy]

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.

Thread closed.