Thread: Autoupdate rows in one sheet with data from another

I was wondering if it is possible to automatically add a row of information to one tab after it has been added to a different tab?
For instance i have been copying and pasting a single row from multiple spreadsheets into a tab on a master one. The next tab is linked to the first, with information pulled out from each row (the same data each time).
Other people will be updating the first tab with further rows and i want the second tab to recognise that data has been added to the first tab and update itself accordingly. (So i don't have to go into the tab, hightlight a row and use autofill each time).

Lacking the specific about the worksheets, here is the basic code to get you started.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim nextrow As Long
    
    nextrow = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row + 1
    
    If Target.Cells.Count > 1 Then Exit Sub
    
    Application.ScreenUpdating = False
    
    If Not Intersect(Target, Range("G1:G100")) Is Nothing Then
        Range(Cells(Target.Row, "A"), Cells(Target.Row, "G")).Copy Sheet2.Range("A" & nextrow)
    End If
    
    Application.CutCopyMode = False
    Application.ScreenUpdating = True

End Sub

This code uses sheet code names -- not worksheet (tab) names. You may need to revise the sheet code names and certainly the range references.

The code works as follows:
Column-G is the "last" entry column. When a cell in the range of G1:G100 is changed, the range of cells from A:G, for that row, are copied to Sheet2.

This code must be placed in the module of the worksheet in which you are entering the data.

How to add the code

1. Right-click the sheet tab of the target sheet, choose View Code
2. Copy and paste the code into the VB Editor
3. Make any necessary changes to sheet and range references
4. Close the VB Editor