Hi,
I need a VB to change Col Q which contain "YES" to data at Col H (The rest col remain untouched)
and possible to merge with this VB Code?
Sub S2_AddZero()
Dim a
Dim i As Long
Dim R As Range
For Each R In Range("D2", Range("D" & Rows.Count).End(xlUp))
If...