Useful Macros - 8 : Automatic Data Transmission Between Sheets

Automatic Data Transmission Between Sheets Of Workbook

 A great excel data copying example.     

 The entered values into  the range A1: R4000 of Sheet1 are automatically copied to other sheets of the workbook.

 We added to copy the following VBA codes to Worksheet_Change method of Sheet1:

Private Sub Worksheet_Change(ByVal Target As Range)
    Worksheets.FillAcrossSheets (Worksheets("Sheet1").Range("A1:R4000"))
End Sub