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
    Selection.AutoFilter Field:=2, Criteria1:="4C.MT2.P1.EN"
    Selection.AutoFilter Field:=2, Criteria1:="=4C.MT2*", Operator:=xlAnd
    Rows("1:222").Select
    Selection.Copy
    Sheets("M2 PCS EP").Select
    ActiveSheet.Paste


    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

  • Re: Copy selected data to new worksheets via macros


    Hi,


    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..


    HTH.

Participate now!

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