madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hey Guys, I need your help to solve my issue. In my sales report I column i have to find my completed tasks. Typically to identify tasks in I column, it will start with cell contains Completed Task and ends in cells contains *****. Some time some cells contains ***** alone which is incomplete task(See the example below). Now the macros should find the Completed Task and ***** combinations to mark with start and end in G column. Please heads up. Thank you.
Scenario:
<tbody>
</tbody>Requirement:
<tbody>
</tbody>
Scenario:
G | H | I |
DDDDDDD | ||
WWWWW***** | ||
Today Completed Task | ||
XXXXXXX | ||
YYYYYYY | ||
ZZZZ | ||
XXXXXX ***** | ||
VVVVVV | ||
BBBBB***** | ||
Yesterday Completed Task | ||
RRRRRRRR | ||
WWWWW | ||
VVVVVV***** | ||
<tbody>
</tbody>
G | H | I |
DDDDDDD | ||
WWWWW***** | ||
Start | Today Completed Task | |
XXXXXXX | ||
YYYYYYY | ||
ZZZZ | ||
End | XXXXXX ***** | |
VVVVVV | ||
BBBBB***** | ||
Start | Yesterday Completed Task | |
RRRRRRRR | ||
WWWWW | ||
End | VVVVVV***** | |
<tbody>
</tbody>