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