Hey everyone, please see code below, can someone help me identifying why it does not fill down the formula on the "Management" sheet until the end of the list on sheet2?
The last 8 or so names on the table of sheet2 are not appearing on sheet Management?
I've also uploaded two images... Thanks in advance!
Or if there is any other quicker and easier way to link those cell in the Management sheet with the list on sheet1?
The Management sheet is basically a mirror of that list, however the list on sheet1 changes often and therefore I don't want any REF! appearing on Management sheet and also I want to be able to filter it sometimes so I don't want to just put a formula and fill down until the end otherwise when filtering I will have loads of empty cells at the top.
Thanks in advance
The last 8 or so names on the table of sheet2 are not appearing on sheet Management?
I've also uploaded two images... Thanks in advance!
VBA Code:
Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
With ThisWorkbook.Sheets("Management")
'.Unprotect ("notnow")
Sheet1.Range("A10").Formula = "=sheet2!A2"
Sheet1.Range("A10:A" & Sheet2.Cells(Rows.Count, 1).End(xlUp).Row).FillDown
'.Protect ("notnow")
Application.ScreenUpdating = True
End With
End Sub
Or if there is any other quicker and easier way to link those cell in the Management sheet with the list on sheet1?
The Management sheet is basically a mirror of that list, however the list on sheet1 changes often and therefore I don't want any REF! appearing on Management sheet and also I want to be able to filter it sometimes so I don't want to just put a formula and fill down until the end otherwise when filtering I will have loads of empty cells at the top.
Thanks in advance