Copy data down and across range

  • Hi Team,


    Thanks in advance



    I have multiple variable which individually value by below with my required criteria auto filters


    count1 = .AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible).Cells.count


    filter2


    count2 = .AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible).Cells.count


    filter3


    count3 = .AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible).Cells.count


    and go on...............



    and for that I have defined below variable


    Dim count, count1, count2, count3, count4, count5, count6, count7
    Dim count8, count9, count10, count11, count12, count13, count14
    Dim count15, count16, count17, count18, count19, count20 as long


    these each 20 count need to take from 4 excel files and then store to the one new file. after completion of one excel for next excel I have to redefine above variable like



    count1 = 0
    count2 = 0
    count3 = 0
    count4 = 0
    count5 = 0
    count6 = 0
    count7 = 0
    count8 = 0
    count9 = 0
    count10 = 0
    count11 = 0
    count12 = 0
    count13 = 0
    count14 = 0
    count15 = 0
    count16 = 0
    count17 = 0
    count18 = 0
    count19 = 0
    count20 = 0


    is there any idea seniors to create loop for that..


    thanks so much will b very great full

  • Ha ha, I guess so.


    ever thought of some youtube videos which would explain how you make the very flexible Excel, even more flexible.


    Many thanks to all the supporters at Ozgrid.

  • Ha ha, I guess so.


    ever thought of some youtube videos which would explain how you make the very flexible Excel, even more flexible.


    Many thanks to all the supporters at Ozgrid.


    I didnt get that ? what do you mean to say please explain

  • Hello Rmrekoj


    It is recommended that you start your own thread ...:smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)