Mirror Entries on One Excel Worksheet on Another Worksheet

Mirror Entries on One Excel Worksheet on Another Worksheet

July 13, 2015

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:

 

http://stackoverflow.com/questions/26755413/construct-a-pair-of-mirrored-cells-in-two-different-worksheets

 

 

 

 

 

 

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com