Copy & paste...if

  • Thread starter Thread starter saintsmandavid
  • Start date Start date
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 -
 
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.
 
Back
Top