Hello Mike,

Thank you very much for your response.

However this vba still does the same as mine does.

Maybe i didn't explain this as well as i could have.

What i want it to do is check cell AN2 for the word Amount then if an2 is there populate decimal in ag2 then 18 in ah2 and 3 ai2 which it does already.

then once it has checked for amount, description, date etc in an2 i want it to then check an3 for the same and then if its description I want it to populate CHAR in ag3 50 in ah3 and nothing in ai3 then move on to an4 until it reaches a blank..

Hope that make a bit more sense, again thank you for trying to help!