| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup specific text, then apply rules
I need some code that will allow me to search for the word "CANCELLATIONS",
then take that line and every line following it until a blank cell appears. Then I need it to copy that text to 'Sheet3', and continue the search for any other "CANCELLATIONS" that exist within the sheet...and do the same thing for the rest of the sheet.... NOTE: all data being searched is in column "A". Any help is appreciated, JB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
| Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
| Lookup Function - Specific Values | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Hybrid Mode
