S
saintsmandavid
I want to copy from col B & paste to a new sheet if col A = yes, then
sort low to high
ColA ColB result
yes 10 10
yes 12 12
no 5 30
no 10
yes 30
no 12
I use named ranges for each column & colA can contain up to 6
different values - colB is always a number
Can anybody come up with a macro that can manage this -
sort low to high
ColA ColB result
yes 10 10
yes 12 12
no 5 30
no 10
yes 30
no 12
I use named ranges for each column & colA can contain up to 6
different values - colB is always a number
Can anybody come up with a macro that can manage this -