Copy selected data to new worksheets via macros

  • Hi there,
    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 there an easier way to automate this as the way I am doing it seems to be very drawn out

  • Re: Copy selected data to new worksheets via macros


    Welcome to the forum.

    Autofilter is the better option in selecting the data which meets a specific criteria. You can try applying the same to other data sets as well and post back with details, if you have any difficulty in doing so..


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!