• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Loop through fixed number of rows

Status
Not open for further replies.
C

Cammandk

Member
I'm looking for code that will loop though O9:O38 and if on any of those rows the first 4 characters = "Cash" then "Cash Withdrawal" will be put in the adjacent J9:J38 cell.

So if O15 = "Cash Deposit abcd " then "Cash Withdrawal" will be entered into J15


▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as a new one created in VBA forum.
​
 
Cammandk said:
I'm looking for code
Click to expand...
As here it's the Excel forum so for formulas
I hope you are talking about a formula ?!

And even if a VBA code is needed (so see the appropriate forum)
the efficient way is to use a formula as it no needs any loop
with only two codelines !
​
 
Status
Not open for further replies.
Back
Top