Look for value in column B and copy if to several cells i column A

[a94andwi]

Hello.

In the attached file I want to look for the text IOH in column A.
When the loop finds IOH I would like to copy the value in column B to all rows below on column A until the next IOH appears.
Then the loops copies the new value in column B and continues.

I have attached a file where you can see how it looks and how the result of the macro should look like.


I hope you can help me with this.

Kind regards
AndersNettobehovslista.xlsm

[sktneer]

Try this....

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[PCI]

Try
BTW your explanation is very clear and your file well prepared: Thx

Please Login or Register  to view this content.

[a94andwi]

Thanks a lot. This worked perfectly for me!!!

[sktneer]

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.