jenit
asked on
Excel VBA - Loop and find cells containing specific text - if found paste a specific value 12 columns to right
I'm having problems with this.
I need to search thru column A starting at A2 and look for cells containing the letter D. If the letter D is in the cell (col A only) then I need to paste "10%" in the same row 12 columns to the right. This needs to loop thru until then end of the data set (no blank rows).
I need to search thru column A starting at A2 and look for cells containing the letter D. If the letter D is in the cell (col A only) then I need to paste "10%" in the same row 12 columns to the right. This needs to loop thru until then end of the data set (no blank rows).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jenit..You are welcome..and Always happy to help..and yeah thats what we are here for to help as much we can.. :-)
ASKER