I am trying to develop a macro that copies data from one workbook to another,
however looks up the date in wb1, then finds the same date in wb2, and copies
values from wb1 beside the matching date in wb2

e.g. wb1 date 07/07/2007 ,wb2 (monthly report, dates from 1/07 to 31/07/2007
in a column) When macro runs, looks up date in wb1 and then copies data from
wb1 to wb2 if if finds same dte in wb2, otherwise says no data to update,

can anyone help???
Thanks Tiger