G Guest Jun 22, 2007 #1 I want to enter the same data in different worksheet and in different cell at the same time..
G Guest Jun 22, 2007 #2 Hi, Select your cell in the 'different' workbook and type = navigate to your first workbook where you will enter the data and select the approriate cell. Press the green tick Mike
Hi, Select your cell in the 'different' workbook and type = navigate to your first workbook where you will enter the data and select the approriate cell. Press the green tick Mike
G Guest Jun 22, 2007 #3 Either use a link or: Private Sub Worksheet_Change(ByVal Target As Range) Set r1 = Range("A1") If Intersect(Target, r1) Is Nothing Then Exit Sub r1.Copy Sheets("Sheet2").Range("B2") End Sub Will automatically copy data entered in cell A1 to Sheet2 cell B2
Either use a link or: Private Sub Worksheet_Change(ByVal Target As Range) Set r1 = Range("A1") If Intersect(Target, r1) Is Nothing Then Exit Sub r1.Copy Sheets("Sheet2").Range("B2") End Sub Will automatically copy data entered in cell A1 to Sheet2 cell B2
