I have a workbook with 2 worksheets, sheet1 and sheet2


I am trying to create a vba module that will place in cell A1 of sheet1, the value of the cell comprising column a of the active cell's row in sheet 2.

So for example if cell C50 of sheet2 was highlighted, and the value of A50 = 3/7/2013, cell A1 of sheet1 should = 3/7/2013.


Any thoughts?