I am trying to automate a worksheet to able me to input data into a worksheet and then split out the data into different worksheets for ease of creating charts etc. I have used the autofilter and the macro recorder and have came up with the following:
Selection.AutoFilter Field:=2, Criteria1:="4C.MT2.P1.EN"
Selection.AutoFilter Field:=2, Criteria1:="=4C.MT2*", Operator:=xlAnd
Sheets("M2 PCS EP").Select
There is 9 more data sets that i need to copy...is there an easier way to automate this as the way I am doing it seems to be very drawn out