Run code when date =TODAY()

I have a spreadsheet (TY08 Comp Prog) with dates from January 1st, 2007 through April 30th, 2008 in Column B.

In a separate spreadsheet (f_list) I have a field that always shows today's date =Today() and also has data that I want to collect and paste to the TY08 Comp Prog spreadsheet. The data on this spreadsheet changes every day.

Is there a way to get the data from the f_list spreadsheet to post to the TY08 Comp Prog spreadsheet when =Today() equals the date entered in Column B of the TY08 Comp Prog?

Basically I want code to run when =Today() matches a date that has already been entered on my TY08 Comp Prog spreadsheet.

I'll write the code to copy the data, I just need a way to trigger the code to run.


I have to rest now, my head hurts,

ToOfWe.