| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to copy and paste based on a condition
The status will be input in A1, eg: term
The input in A1 must, of course, match exactly (except for case) with what you actually have in the status DV col in Sheet1's col B. If you have it as "Terminate", then input the same text in A1. And if you change the input in A1 to: Retain, it'll return the result lines for "Retain" cases. Great flexibility there. Instead of inputting, you could also just paste the same status DV into A1. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
| Copy and Paste based on Condition | Excel Discussion (Misc queries) | |||
| How do I copy a set of cells based on a logical condition | Excel Discussion (Misc queries) | |||
| copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
| Copy Row based on a condition | Excel Worksheet Functions | |||
Threaded Mode
