VBA Loop. If true then copy this data into column A

Hi,

I am trying to loop through my data and if the data matches the Code and then next two columns are blank then look at the next row. If that is the Team then paste the code in column A and the Team in column B.

HTML Code: 

However I am struggling

I have used this kind of loop before when looking for a date but i was able to use the IsDate function so was easier.

Would appreciate any help.

Many thanks

Perhaps someting like this will work.

Please Login or Register  to view this content.

As Maxrow is not a VBA command as far as I know I've set an arbitrary value of 100 for this since I don't know this value.

Alf

Thanks for rep

If this solves you problem don't forget to mark thread "Solved" as pr forum rules.

Alf