save another sheet of excel

respected,

from the receipt i want to save the receipt date into another location but with the
roll number
e.g
if i enter roll number 1` it must save the date in the ahead of roll number
if i enter roll number 2 it must save the date in the ahead of roll number

hope for your soon reply

regards,

makhdoom