Planning monthly deductions
 

Hi

I'm trying to set up a home budget workbook. We have four different
bank accounts, and each has its own worksheet.

On a fifth sheet, called 'Data', I want to have a table (range b16:e20)
with the following headings: Day of Month, Account, description,
Amount. There is also a sries of cells which look at the date (
=3Dtoday() ) and breaks it down to day-of-month, day of week, month,
year long, year short.

Is there an easy way that I can have the worksheet, on opening, look at
the table, check the date, and put the correct debit on the next
available line of the appropriate bank account.

For example, there is an entry in the table:

01 (day of month), Barclays (account), ISP (description) and =A315.99
(amount).

If I open the workbook on the first day of the month the 'd-o-m',
'description' and 'amount' details will fill to the next row on the
Barclays worksheet.

I hope this makes sense.

Thanks in advance

Steve