Hi Matt,

First question is do you want a macro to do this? If so then the possible
methodology is:-

A Macro to automatically run when the workbook is opened.

Initially the macro should compare the current date with a date saved
somewhere out of the way in the workbook.

If the current date is greater than the date saved in the workbook,
automatically run a process to append the previous day/date and the required
value to the list and then copy the current date to the saved date in the
workbook.

The above would then only allow the process to take place the first time the
workbook is opened on any day. All future opening of the workbook during the
same day will compare the current date and saved date as equal and so exit
the procedure.

If you would like me to write the macro as above then let me know. However
it will help if you can answer the following for me:-

Do you require instructions to copy the macro into the workbook? (It will be
a Workbook level event).

In the list created, will it be only weekdays or all days of the week? It is
possible to test for the previous day to check if Sat or Sun and use Fri in
lieu if that is what you want.

Do you only want the Day of Week or the Day of Week plus the Date shown in
the list.

Name of the worksheet and the cell address where you want to start the list.

Is the value to be copied always from the same cell address? If so, name of
the worksheet and cell address. If not, I will need some info on the setout
of the sheet so the macro can locate it. For example always at the bottom of
a list commencing at cell D1 or always the last cell in column D.


Regards,

OssieMac