VB macro in xls help

[mikeco]

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

[willakawill]

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

Hi. This does not differ significantly from normal vb. You need to open a code module in Excel and put your code in there. If you don't know anything about vb then you should get a vba book focusing on excel