| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro puts text if keyword is found in cell above
I have a sheet . in A column i have cells with text , and empty cells . I want the macro to search the column for given keyword . If found , to go to next cell in A column . If that cell in empty , it should put "No description" . If that cell is not empty , it should leave it as it is . Example : keyword : mother A1: mother goes home A2: house A3: empty A4: my mother is ... A5: empty So , A5 should become : "No description" Thanks ! -- andrei ------------------------------------------------------------------------ andrei's Profile: http://www.thecodecage.com/forumz/member.php?u=1056 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=201969 http://www.thecodecage.com/forumz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that delets rows if keyword is found | Excel Programming | |||
| Macro that concatenates content from cells if given keyword is found | Excel Programming | |||
| Macro analyses Cell.Serches for given word,the puts text in cell a | Excel Programming | |||
| Macro - reads cells in a column .If keyword found moves cell conte | Excel Programming | |||
| Macro searches for keyword. If found , puts 0 in cell from next co | Excel Programming | |||
![andrei[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
