Copy & paste...if
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 - |
Copy & paste...if
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 - |
All times are GMT +1. The time now is 10:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com