Copying the data based on the cells availability and Loop it

  • Hi,
    I am working a scenario. which is " filter specific combination in sheet A and paste in Sheet B of cell A1 and for next loop data should copy available rows of Column A5000 (From the available cells in the previous step) and looping continues until it is complete.


    Please find my code below:


    I am looking some coding suggestion in ('Comment places)



    Please let me know if you need any further clarifications on this..



    Regards,
    Sri

  • Re: Copying the data based on the cells availability and Loop it


    Hi,
    Sorry for the late response.


    Using the attached file data, I have do the below actions:


    1. Filter "Column19" on "AGENTorDRM"
    2. Filter "Column8" on "KAX0"
    3. Again Filter "Column18" on "0"
    4. Then Copy Column H, P, X and copy it to new sheet called "Agent&DRM"
    5. Replace “KAX0” to “AAX0”

    Do the above steps from KAX0 to KAX9 to gather the data to get the required info. At the end of the loop should have all data for "AGENTorDRM", KAX0 to KAX9 (AAX0 to AAX9 – as we are renaming it) and indicator “0”


    In my first message, I tried the little coding part for this scenario. Please help me to get the coding for the above scenario using looping.


    Please let me know if you require any additional information on this scenario.



    Regards,
    Sri

Participate now!

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