I am currently trying to create a macro that finds a cell with a certain word and selects all cells in a row only if they contain data and replaces that data. This is what I have so far.
If Trim(rngCell) = "Bead Lot" Then
rngCell.Offset(0, 1).Select...