top of page

Mirror Entries on One Excel Worksheet on Another Worksheet

I found some code online that will automatically transfer entries made in a columns or columns on one worksheet to another worksheet. An example of where this would be helpful would be if you were entering basic coding information for documents on the first worksheet, and then wanted the bates numbers entered in column automatically copied to the second worksheet so you could input issue codes. Follow these steps if you're using Excel 2010:

1. On Sheet1, right click and select 'View Code'

2. In the Visual Basic window that opens, select 'Worksheet' from the drop down menu on the left, and 'Change' from the drop down menu on the right.

3. Replace the entry above the dividing line which reads:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

with this code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column <> 1 Then Exit Sub

Worksheets("Sheet2").Range(Target.Address).Value = Target.Value

Range("A:A").Copy Worksheets("Sheet2").Range("A:A")

End Sub

4. Now when you enter bates numbers in column A of Sheet1 . . . .

5. They will automatically appear in column A of Sheet2.

Obviously you can change the range to have data automatically transfer from more columns on Sheet1.

I honestly can't determine which site I found this code on, but the heart of the code is described here:






bottom of page