Add Row & Loop

Good Afternoon

I have a sheet with data, in last column I have value "Y" or "", I have a code that goes down last column and looks for Y and adds new line above "Y" value, loops through till done. My problem is that it's not doing it for all the "Y" values it is skipping some. I did add sheet to explain what I am doing.

Thanks

Thanks Bishonen

Works great. I just realized that after it add the new line I need the Customer Code in column A in new row, How would I go about doing that? I tried to get an easy way around it but looks like it's gonna take me 100 steps to do that...

Thanks

Just to make sure that I understood you correct: after the inintial macro has done its work, you would like to have AND089 in "A31", AMY012 in "A20" etc?