Cell Reference?

[ie12041952]

This should be pretty straight forward but I can't get it to work. I want to be able to enter a date in a cell in the first sheet and have it auto-fill a cell in a second sheet. I'm able to do that but when I sort the data in the first sheet the date in the second sheet changes to whatever date is now in the referenced cell. I've tried every combination of cell references and also tried to link the cells but in all cases the date changes when sorted.

I'd appreciate any help. Thanks.

 

[mrmmickle1]

Use a worksheet event. It will hardcode the values into the cells rather then using a formula:

'This code goes in the Sheet1 worksheet code module
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 Then 'Check if the data is being entered into column 1
        Sheets("Sheet2").Range ("A" & Target.Row) 'if so duplicate the data entered in column 1 in Sheet2
    End If
End Sub

How to insert code:
https://www.ablebits.com/office-addins-blog/2013/12/06/add-run-vba-macro-excel/

 

[Norie]

Name the cell in the first sheet and use the name in the formula on the second sheet, then whenever you sort the first sheet should still refer to the same cell even if it has moved.