Link to home
Start Free TrialLog in
Avatar of jenit
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).
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jenit
jenit

ASKER

that is Awesome, it works perfectly - THANK YOU!    It is people like you and forums like this who make me - the dabbler in VBA look good!
Jenit..You are welcome..and Always happy to help..and yeah thats what we are here for to help as much we can.. :-)