Daily Excel Reports, repetitive daily tasks

I log onto FedEx.com daily and get reports for two different FedEx accounts. There are things that I do repetitively each time I pull the reports at the end of the day. They are all very simple tasks, like formatting and rearranging the columns, etc. Is there any way I can program Excel to run these tasks automatically?

Here is what the spreadsheet looks like.

Tracking number: Service: FedEx Freight Service Guarantees: Your reference: Company:
777711112222 Priority Overnight N/A 10.13 - 525682, 525694 ABC
777711113333 FedEx 2Day A.M. N/A 10.13 - 88143, 91757 XYZ
777711114444 Priority Overnight N/A 10.13 - 525668, 525669 JKL
777711115555 Priority Overnight N/A 10.13 - 525696 MNO
777711116666 FedEx 2Day A.M. N/A 10.13 - 525695 GHI
777711117777 Priority Overnight N/A 10.13 - 525700 DEF
777711118888 FedEx 2Day A.M. N/A 10.13 - 525703 WXY
777711119999 FedEx 2Day A.M. N/A 10.13 - 88127 RST
777711110000 Priority Overnight N/A 10.13 - 88122 QRS
777711121111 Priority Overnight N/A 10.13 - 525103 BCD
777711123333 Priority Overnight N/A 10.13 - 525705 TUV
777711124444 Priority Overnight N/A 10.13 - 525708 VWX
777711125555 Priority Overnight N/A 10.13 - 525711 FGH
777711126666 FedEx 2Day A.M. N/A 10.13 - 525712 LMN
777711127777 FedEx 2Day A.M. N/A 10.13 - 88140 ABC123
777711128888 Priority Overnight N/A 10.13 - 88139 DEF123
777711129999 Priority Overnight N/A 10.13 - 88135 GHI123
777711120001 Priority Overnight N/A 10.13 - 525709 JKL123
777711130000 Priority Overnight N/A 10.13 - 525666 MNO123

I'm not sure why the columns aren't aligned here, but you get the picture, I hope.

I do the following, in this order:
1. Delete column titled "FedEx Freight Service Guarantees" (I don't import this column, it automatically shows up, and I don't need it.)
2. Cut and insert "Company" column over to Column B
3. Sort list by Service
4. Color fields (30% gray) of tracking numbers for any service that is not Priority Overnight
5. Sort list again, this time by Company name
6. Insert a column to the left of Tracking number (after coloring fields, because new cell takes on color of cell to the left)
7. Insert a column to the left of Service (this column remains blank, as it's my check column when invoice comes in)
8. In Column A (to the left of the first Tracking number), I enter the number 1, and continue counting to get a count of shipments
9. I select top row, make all column headings bold and then do some surgery--I remove the colon. ; )
10. I add a new row to the top of the list and add current day and date and some text: Tuesday, 10.14.2014 - FedEx
11. I format new row to be BOLD, 18 points and centered between the four columns
12. At the bottom row, beneath last shipment, I either copy and paste new top row (to copy formatting), or use the format paintbrush, and type in the word "TOTAL:" and put in the number of shipments being sent that evening.

Whew! I think that's everything! They are all minor tasks, not VERY time consuming, but it would be awesome if I can get all (or most) of these tasks done in one fell swoop. I do this daily.

Thank you, thank you, thank you!!!

-Lisa

You could do most of that quite easily by recording a macro and going through the actions one by one.
With a little bit of tinkering with the code you could quite easily have it all happen at the click of a button.

Thanks! How do I go about creating a Macro?
It's a combination of being more pleasing to the eye as well as serving a function of tracking packages and billing. I've never created a macro before. ...But there's a first time for everything!

If you have the "Developer" tab visible on your ribbon you can select that and there will be an option for "Record Macro".
Or, depending on the way you have Excel set up there's a small blue and white square icon with a red dot at the bottom left of the screen. Clicking this will also start the macro recording.
You then stop the macro recording when you're done in the same manner.

Without sight of your raw data layout and the expected results, it's difficult to provide you with custom made code for this.

BSB.

Thanks. I don't see either of those options, though.

Yes, I found it, thanks! I just have to make it work now. I've done six or seven attempts, but there are still flaws. I need to shade certain cells depending on the data of other cells in that row.

For example, anything that is NOT Priority Overnight should have the Tracking # shaded.

Addendum: If data in column E (labeled "Service") is any value other than Priority Overnight, then contents in Column B (labeled "Tracking number") should have a 30% grey shaded background.

Thanks, Judgeh59. I did...see original post. I don't know how to upload, so I copied and pasted in the original question. Thanks!

Okay, I hope I uploaded file samples properly. Thank you!!!