Offset function, adding column and save-as

I suggest you RECORD macro taking the steps you have mentioned and edit the recorded macro. it will also be a good exercise to learn macro