| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy values from one column to another with criteria
Hello all,
I am trying to copy all of the information in column A that starts with "TC*" to column B. I would like to make this part of a macro but im unsure how to get excel to select the cells in column A based on this criteria. What my intended goal is to actually delete all entries in column A that dont start with "TC*" or "MV*" . The only way I could figure to do this was to copy them to column B, delete column A and then copy them back.. but if anyone has a better way to do this please lend me a hand. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging values in column A when certain criteria are met in colu | Excel Worksheet Functions | |||
| How do I count values w/ criteria located in more than one column | Excel Worksheet Functions | |||
| To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
| Sum the values of one column, only if they meet certain criteria . | Excel Worksheet Functions | |||
| Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
Threaded Mode
