change source data br loop each loop in array vba

[daboho]

i have data with criteria1 ,criteria2,criteria3 ...and so ..on
my criteria can see in my coding mycr(1) until mycr(7)
source criteria is sn,
first loop criteria is sn ,second loop source data change ( i want first criteria is in sn to erase)
third criteria data in source sn change again so until mycr(7)

MY QUESTION IS CAN DO LOOP READ DATA FROM SOURCE ARRAY TO BE CHANGE BY Loop

Please Login or Register  to view this content.