simplifying macro coding (removing.select mostly)

hi everyone,
I need some help figuring out how to simplify some of my coding (i'm fairly new and still use a bunch of .select

the macro selects two rows from a template and pasts it into a report, then it autofilters data and copies visible cells over to paste below the template rows.
Here is what I use right now (the section only)

Please Login or Register  to view this content.

How could I simplify this?

I'm also loosing some of the formatting when I paste the cells (certain rows are supposed to be bold but formatting is not copied)



Thank you