i have multiple columns with a name followed by five #'s as such:
Name
#1
#2
#3
#4
#5
i'm want to loop through each column, and when criteria are met (ex:#4>#1), copy that column to another location and sort the numbers. i have a problem thinking in vba code, and i can't figure out how to code this logic:
for each column b to e, if row 5>row2 then....
the copy and sort which follows i think i got. Any ideas?
Name
#1
#2
#3
#4
#5
i'm want to loop through each column, and when criteria are met (ex:#4>#1), copy that column to another location and sort the numbers. i have a problem thinking in vba code, and i can't figure out how to code this logic:
for each column b to e, if row 5>row2 then....
the copy and sort which follows i think i got. Any ideas?