When I change a value within a range on sheet2 (where I have this code) I want the value to appear in that same location in sheet1. Here's my codeThanks in advance!![]()
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim rowval As Integer, colval As Integer If Intersect(Target, Range("A1:L5")) Then rowval = Target.Row colval = Target.Column Worksheets("sheet1").Range(Cells(rowval, colval)) = Target End If End Sub
Bookmarks