I have a worksheet with a column that has certain job descriptions. DL, IDL, MOH, G&A, and Other MOH. Basically I don't need all of these and would like a macro to:

1 Delete All Rows With status INATIVE from column I
2 Add a column between Columns I and J
3 Move columns K and Q to the right of Column I
4 Do a vlookup in column L (=VLOOKUP(I2,'DL List'!A2:B34,2,0)) and convert the formula to values in column L
5 If the description is DL in column K then it should be DL in column L all other descriptions in column K (IDL, MOH, G&A, and Other MOH) should be converted to IDL in column L

Can someone please give me a way to start this code?