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 (
=today() ) 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 £15.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

Yes you can do this, the pseudo code would be something like......

Workbook Opens
Get current date from system
Read table
If Date Found then Copy Row to relevant worksheet
End

But it is not entirely clear what you are doing.? The table on the fifth
sheet presumbly holds all past and future records for every account? You
say when you open the sheet on the first day of the month, but what happens
on other days and is it only the specific entries in the table with that
date that need copying or all future records?

--
Cheers
Nigel



wrote in message
oups.com...
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 (
=today() ) 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 £15.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

Nigel, thanks for replying.

The fifth sheet contains all the lists that are used in dropdowns on
the other 4 sheets.

I also want it to have a list of my standing orders: mortgage payment
from the Lloyds account on the 5th of the month, Council Tax from the
Barclays on the 1st, ISP from HSBC on the 15th, etc.

The workbook will be opened every day as my wife is almost rabid about
monitoring cash. :)

The idea is that, if we open the workbook on a day of the month where a
standing order is due to go out, the information is copied to the
relevant cells on the appropriate account's worksheet.

It's intended so that we can record our daily spending and look at a
correct and current balance, without having to remember to input the
mortgage on the 5th, the ISP on the 15th, and so on.

Steve