Have you considered using an autofilter, filter column A for 'Yes', then
copy-paste the visible column B to another place, then sort it?

Can all be done in code, try it by turning on the macro recorder.

--

Regards,
Nigel




wrote in message
...
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 -