Dear All,
I have a sheet in which i have 4 columns. Every day one record will be inserted.
So whenever a record is inserted the cells of the latest inserted record should be inserted into another sheet in the new row.
Ex:
Sheet1
date data1 data2 data3 data4

22/3/2010 3 3 3 5

So in sheet2 the data should be

date data1 data2 data3 data4

22/3/2010 3 3 3 5

Thanks in advance.