Automate hiding columns, adding columns, inserting formulas, and filtering

Hello everyone,

I get a weekly digest report, and I was hoping to have a macro run some of the tedious manipulations I make to that report.

The list of steps I follow are:
1. Add new column before "Subject": "IDW"
Paste formula in "IDW": '=RIGHT(B2,LEN(B2)-31)'
Drag down
2. Add new column before "Sent on": "Sent"
Paste formula in "Sent": =IFERROR(LEFT(H2,FIND(" ",H2))+0, "")
Drag down
3. Filter Columns
"Subject": Deselect "Please DocuSign this document: Wave 1_BHSF IDW_301-302_slf_v1_160829.pdf" & "Please DocuSign this document: TEST_IDW.pdf"
"Status": Deselect "Voided"
"Action": Deselect "Completed" & "Created"
4. Hide Columns
"Subject"
"Status"
"Sent on"


Thank you!