Run a macro with date/cell change
 

Hi,

I have a macro that copies and pastes data once a day. I would like to be
able to run this macro upon a date change. The data I copy daily is linked to
an external source that updates continuously. Whenever a new day begins, the
cell that is linked to the date will rollover to a new day. So I would like
to be able to run that copy and paste macro whenever that cell changes to a
new date/changes at all.

Thanks,
Darren