Hi, i need some help. I try to google but see hard for me
In myweeksht;
At Column D
1. Find WPxx And Replace with 'Poster'
2. Find number (the number can be single or double digital) And replace with 'Route'
<tbody>
</tbody>
2nd part is
In myweeksht;
At Column E
Find Index and replace Col D to Index
<tbody>
</tbody>
In myweeksht;
At Column D
1. Find WPxx And Replace with 'Poster'
2. Find number (the number can be single or double digital) And replace with 'Route'
Col D | Col D (Result) | |
WP1 | find WP @ Col D & replace with 'Poster | Poster |
WP2 | '' | Poster |
5 | Any numbers found @ Col D will replace with 'Route' | Route |
1 | Route | |
3 | Route |
<tbody>
</tbody>
2nd part is
In myweeksht;
At Column E
Find Index and replace Col D to Index
Col D | Col E | |
1 | Index | find Index @ Col E & replace with with 'index' at Col D |
5 | Index | find Index @ Col E & replace with with 'index' at Col D |
6 | Index | find Index @ Col E & replace with with 'index' at Col D |
<tbody>
</tbody>
Code:
With Range("Q:Q")
.Replace "Yes", "=xxx", xlWhole, , False, , False, False
.SpecialCells(xlFormulas, xlErrors).FormulaR1C1 = "=rc[-9]"
.Value = .Value
End With
Last edited: