Can someone help me convert this to VBA code?

If .......(I've got this part)

Then
Copy the rows 5 through 50 in the column behind the one you are currently in (offset 0,-1 I believe)
Now paste special values that colum in some random column (YY?)
Now copy the same data you just pasted in YY and go back to the original column you were working in and past special "Subtract"

Thanks!