I have a sheet (named "LookupLists") listing some Products, a day of
the month, and unit costs in adjacent columns.
Each month when that particular day of the month arrives, i wish to
copy the appropriate cells, and paste into a sheet called "pm" adding
the data to the bottom of the list.

Is there a way to automate this?
So when the file is opened, this procedure runs, and it checks the
dates, and copies accordingly?

A thought...What about if the File is not opened when a day of the
month comes and goes? If the file is opened, say tomorrow, and a
product should have been copied today, could it copy that too,
ensuring that it hasn't copied & pasted it already?

Preciate your help on this one.

Thanks
Mik