Hi there,

I have a spreadsheet with sheet 1 having values in cells a4, b4, and c4 €¦.
date being in cell a4 (=now() ).

I want to copy it each day to sheet2 with the date being in cell a1 and the
rest in cell b2, c1, d1 and the next day the data will go to a2,b2,c2, and d2.

In other words each day I want it to determine if todays information from
sheet 1 is in sheet2€¦if it is copy over existing data€¦. Or if date is
different then copy the days data in the below row. Each day the next days
data will get copied below.

Thanks very much

SD