Hi there,
I was wondering if someone could help me in writing a code for excel.

If values in a cell A1 in sheet 1 is equal to values in cell A1 in sheet two then excel copy and paste values in whole row 1 in sheet 2.

Explanation:

I have set conditions that all data in different cells in sheet 1 is gathered in such a way which is linear (all data of sheet 1 in one row). but problem is each time for new information i have to copy and paste special data gathered previously so that information is not lost.

Please help me write a code that do this for me.

Thanx