Copy data from one sheet to another sheet in excel

Closed
gagandeepc
Posts
1
Registration date
Thursday May 2, 2013
Status
Member
Last seen
May 2, 2013
- May 2, 2013 at 12:59 PM
Hello

i am having data in sheet one against date in column A1 and i want to paste date in sheet 2 against same date after this i want to change date in sheet 1 in A1 column but data not change in sheet 2 A1 column and aginst new date data will be copied in A2 rows in short how can we freeze values of sheet 1 A1 row in sheet 2 A1 row and while we are changing data in sheet 1 A1 row and change data will paste in sheet 2 A2 row