Make VBA macros for excel spreadsheet

Video and Instructions below - sample raw file attached [login to view URL] 1. Delete columns G to M 2. Delete column A - Video says delete cells but it leaves the column in Date format, delete column shown a bit furthr in video ***(Alternative 1 if possible - I can easily do the save myself save as to xlxs ( you can leave this out or put it as first step if possible ) ***Note for Step 2. Ignore the the fill of column A as mentioned before as it is date formatted so I deleted it 3. Insert new Column A 3a. Enter 1 2 3 etc to end of data in Column A 4. Data Sort column H (Fixp) Largest to smallest 4a Delete all rows with scr in them 5. ***Not shown in Video*** Data Sort Column G (100) 5a Delete all rows that do not have a value in this column 6. Back to Video Data Sort Column A smallest to largest 7. Insert Column before Columnn D (TN) 7a Enter Formula =B2&C2 and copy down 8 Insert Column before Column E 8a Enter Formula =TRIM(D2 and copy down 9 Copy Column E 9a Paste as Value into Column D 9b Delete Column E 10 Insert Column before Column F 10a Enter Formula =D2&E2 and copy down 10b Copy Column F and Paste as Value into Column F 11 Copy Column D to Column Q 11a Go to Data and Remove Duplicates 12 Enter 1 into Column R (R2) and copy 1 2 3 etc to end of data 13 Insert Column before Column E 13a Enter formula =VLOOKUP(D2,R2:S48,2,0) 13b Insert $ signs into formula =VLOOKUP($D2,$R$2:$S$48,2,0) 13c Copy this formula down to end of data 14 Copy Column E and Paste as Values 15 Delete Columns R and S 16 Insert 9 columns in front of Column A 17 Copy Column P to Column H 17a Delete Column P 18 Insert 5 Columns before Column J