Can you please help me...
I am trying to create a macro to copy data from some cells and look up
today's date on a table and paste the info from this date onwards leaving the
previous information for past dates intact. I will be using a button to
start the macro.
e.g.
data
todays date (=today()) in a cell i.e. date = 03/01
A1 1
A2 2
A3 3

table
date column 1 column 2 column 3
01/01
02/01
03/01 1 2 3
04/01 1 2 3
05/01 1 2 3
and so on to end of table

Thanks
Kevin