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

Quote from jl2509

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

o

Quote from Rmrekoj

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

how to do please link if you have

Hello Rmrekoj

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