for loop with an instring

[bruinsrme]

Hello,

I have to loop through column and if column A starts with OJT then change Item type to OJT, else do nothing and continue.

Any help on this would be so appreciated.

A B
Item ID Item Type
GI-WRS-CBT Course
IATA123 Course
OJT-014-33 SOP
OJT-014-26 SOP
OJT-014-39 SOP
OJT-014-35 SOP
OJT-014-35 SOP
OJT-014-35 SOP

[Richard Buttrey]

Why bother with a macro, particularly one that uses a loop which is generally inefficient and time consuming with large data sets when there is a perfectly good standard Excel Function. e.g. in C2 copied down

=IF(LEFT(A2,3)="OJT","OJT",B2)

Then copy the whole of column C and paste it back to B1 as Values. If you really do want a macro then I'd simply code this process rather than use a loop.

[Solus Rankin]

Please Login or Register  to view this content.

[jaslake]

Hi bruinsrme

No looping required

Please Login or Register  to view this content.

[bruinsrme]

John I was able to run the code on my sample data. When I adjusted the code for column v and w I Fran into some issues.
It's been a long day, I will try some things tomorrow.

Thank you everyone

[jaslake]

Hi bruinsrme

Long day for me too...let me know your issues...perhaps we can address them.