Macro - Repeat steps/task when exporting file

[MISSCUTEZ]

Morning,

I have no idea what I'm doing and I hope I can explain this properly.

I run inventory reports 10-15 times a week. Every time I export the file in Excel, I open and do the same 10 steps.

Step 1
I highlight from A6-E6 all the way down to A70-E70 (this changes at times as some reports go to 85, 110, 120). Once highlighted I right click hit delete (shift cell left).

Step 2
I left click on column B and delete the entire column as it is blank and not needed.

Step 3
I left click once again and delete the column C,D and E

Step 4
I cut the heading from D2 and paste it in B5

Step 5
I then select column D and re-size the width to 10.71

Step 6
I cut the headings from H2-L2 and paste starting at C4-G4

Step 7
I enter a basic formula in F6 =D6-C6 and then in G6 =F6*E6. I then select F6 and G6 and copy the formulas to the end of F70 and G70

Step 8
At the end of column G (G71) I enter the =SUM(G6:G70)
Under that G72 I enter a SUMIF to give me the actual loss (=SUMIF(G6:G70,"<0",G6:G70))

Step 9
I highlight G6:G70 hit format and add Conditional Formatting.
Condition 1 - Cell Value Is less than 0 (change format) to red and bold
Condition 2 - Cell Value Is greater than 0 (change format) blue and bold

Step 10
Highlight from A6-H6 down to A70-H70 and hit on the border/slash grid lines and add All Borders


My display pic is a sample of how everything looks at the end. Sorry I could not get the image to insert with the post.

I really appreciate any help.
Thanks

 

[MISSCUTEZ]

Sorry this is the picture I wanted to share