| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - reads cells in a column .If keyword found moves cell conte
Let's say i have a column with lots of cells . Some containt text , some are
empty . Macro should read all the cells . If the given word/character is found , it moves the content in B column . B column should not have empty cells Example : Keyword : mother A1 : mother and father A2 empty cell A3 : mother A4 : son A5 : empty cell A6 : mother and nice The results in B column should be : B1 : mother and father B2 : mother B3 : mother and nice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro searches for keyword. If found , puts 0 in cell from next co | Excel Programming | |||
| Retain cell references when column moves | Charts and Charting in Excel | |||
| Populate a cell based on a keyword it found in another | Excel Programming | |||
| Populate a cell based on a keyword it found in another | Excel Programming | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
Threaded Mode
