In Schedule!A1, put the formula =INDEX('Staff List'!A:A,ROW(A1)) and drag the formula down and right.
If you want something absolutely fully automatic, you could put this code in the sheet module for 'Staff List' sheet
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A:B")) Is Nothing Then
Application.EnableEvents = False
Range("A:B").Copy Destination:=Me.Parent.Sheets("Schedule").Range("A1")
End If
Application.EnableEvents = True
End Sub
One conceptual problem you have is that if you have data in Schedule! column C, e.g. "a", "b", "c" are in A3:C3, and you insert a row into Staff List (e.g. row2) , that column C entry will now be in a different row (e.g. "a" and "b" will be in row 4 while "c" is still in row 3)
Bookmarks