Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy text between delimeters
I am trying to write a macro in Excel to select text between cells
which contain words. Two challenges: 1.) I need to search for a cell that contains only one-single word "item:" and then copy the contents of the cell just-above that cell 2.) I need to search for a cell that contains only one-single word "component(s):" and then copy all of the rows below that until I find a cell that contains only the word "Zip" Any samples would help for either of these challenges ~Vic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy text between two different delimeters | New Users to Excel | |||
Find a string between two delimeters and replace with text | Excel Programming | |||
copy text from 1 workbook to another by macro | Excel Worksheet Functions | |||
Macro to copy only certain text | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming |