How To Convert Recorded Macro To Loop Until No Data On Next Row?

I'm pretty sure this question is ask a lot on this forum but I am still new to VBA and trying to learn the ways of programming. I have just completed recording a macro and realized it's not going to work because my raw data will always be changing row count. Can someone tell me how you insert functions in your macro to loop it? I hope i'm explaining that well enough. Here is my macro I need to loop but I would like to know how to do this on my own if it ever happens again.

Please see attachments. I start off with the Open ASNs spreadsheet. It is just basically formatting for the most part but the reports constantly change in row count.

Attached is a spread sheet I really need help with. The first sheet's "Evaluation Report" and the 3rd sheet's "ZP4RN" raw data is always changing and I don't know how to set up a macro to format it based off content in each cell. The sheets inbetween are the the raw data reports I run daily. I only formatted two blocks of the work sheet in "Evaluation Report" to show you the patterns of colors I would like for each Block of data if it is possible and rotate between the two styles for each block of data . The blocks change in row count every time I run the report so it makes it difficult to format and is very time consuming but there are common things in each block that remain the same which I will list below. Once the macro is completed the raw data sheets wont need to be in the spreadsheet. This is just so you can see what the before and semi after looks like. Besides the formatting I need a formula or macro in the ZP4RN spreadsheet in column J that indexes the value in column B "Material", locates in column D in the "Evaluation Report" finds the value in Q and if that value is greater than or equal to 10 insert text "Needs to be reviewed" back in column J. Please keep in mind that the row count in both reports change. Thanks any one who can help!

Evaluation Report:
Formatting needed
Common data in a "Block" of data is it always starts with Purchase organization in column B and ends when you see the next purchasing organzation in column B. I would like at least one space inbetween them. The word "Schedule Agreement" is always 8 rows down from the word purchasing organization and two columns to the right. Below that if there is a number that starts with 181 in column E it will have Last ASN written out beside and so on . I think the rest of the formatting is pretty self explanatory but I hope this helps!

ZP4RN:
Formatting needed
Formula in Column J needed

I actually attached the wrong evaluation report! This is the correct one