Dear all,
I need help on how to write VB code for macro in xls to check for value that contains BBBBB under “product description column” and replace the column “ product category” with the value CCCCC?
Product Category Product Description
AAAAA BBBBB
Tks very much. I totally have no idea on how to write this.
Mikeco