Copy & paste...if

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 -
 
N

Nigel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top