okay so google is being maddeningly unhelpful here......
so im trying to write a macro that takes the data from a column in one sheet and copies it to the B column in a master sheet starting at the first available cell in column B.
im setting the macro at present to just run on the active sheet so i can just go through the sheets manually as i fill them out.
this is what i have at this point.
Sub PopulatePlayers()
ActiveSheet.Range("b2:b65536").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("Overall Leaderboard").Range("B2").End(xlDown).Offset(1, 0), Unique:=True
End Sub
any suggestions? please and thank you.
Bookmarks