I have a spreadsheet that I would like to create a macros for. I have never used VBA but if you can walk me through it that I'm sure I can get it done. I receive a file and I have to do the following to it:
Font changed to 12
Row Height changed to 45
Custom Sort by Street Name, Number, and Pole Number
Add Header by Document Name
Add Footer Page # of ?

I receive about 75 emails with these files in them over the course of a week which is why I'd like to simplify my process for each one.

I can set a macros for all except the custom sort. Can someone help me figure out how to add the sort or write a VBA to include all of this?

Thanks,