find, if match, then cut, offset. if not match, then cut and offset

Hi guys,

I've got one issue that I can figure out for three days. Of got a sheet with 4 columns. What I want is that the sheet searches for string Prov in column B. If he finds it (For example in B7), then he needs to match A7 with A6. If there's a match, than he needs to cut the whole 7th row and place it in F6 (offset 4,-1).

If he finds the the word Prov in column B but doesn't get a match between B7 and B6, then he needs to cut from A7 to D7 and past in F7.

I hope that it's clear. I've added an example to the post.

Thanks guys.

Try this:

Please Login or Register  to view this content.

Originally Posted by StephenR

Try this:

Please Login or Register  to view this content.

I've danced for 10 minutes in the cafeteria because of hapiness : D Thanks Stephen, it works great : D

My pleasure. Wish I'd been there to see that.

Originally Posted by AlphaFrog

Another one...

Please Login or Register  to view this content.

I haven't tried yours yet but thanks for all the effort. Yours a bit more difficult to understand : ( BUT it looks great. I will keep yours for in case...

once again, thanks for all the effort.