looping though data and copy/paste values based on certain criteria excel

I have a sql query that i pull data into excel. I want to write a macro where it loop through all of the rows of data and paste certain columns in that row into another sheet.

for example:

I wanted excel to copy the carrier name, all the month column charges for each row where Mode = LTL, chg_cat = other, and entry_type = frt....and then paste them into another worksheet in the workbook....