Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Automating copy/paste/paste special when row references change | Excel Programming | |||
help w/ generic copy & paste/paste special routine | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |