Copy and Drag Formula Macro

Hi Guys,

I have created a macro where I can drag and copy the forulma to the next column. The issue I am facing is this that I have created the command button on a seperate sheet and when I click it it runs the macro only if I place my cursor to the next column of the data sheet. My macro is as follows and I have attached the file to show where I would like to copy my formula (From Mar-13 to Apr-13 to May-13 ... and so on) Please see the attached file.

Please Login or Register  to view this content.