I have something that's driving me bonkers
Sub PrepareData()
Sheets("MasterData").Select
Rows("1:1").Select
Selection.AutoFilter
'** Routines to delete large unecessary portions of file, i.e, wrong area
Selection.AutoFilter Field:=1, Criteria1:="CAC"
Range("A1").Select
AA =...