Copy Formula from 1 column to the other

[aounhanif]

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) Please see the attached file.


Sub UpdateBS()
Sheets("YTD Balance Sheet").Select
' Keyboard Shortcut: Ctrl+b
'
ActiveCell.Offset(0, -1).Range("A1:A2").Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:B2"), Type:= _
xlFillDefault
ActiveCell.Range("A1:B2").Select
ActiveCell.Offset(3, 0).Range("A1:A73").Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:B73"), Type:= _
xlFillDefault
ActiveCell.Range("A1:B73").Select
ActiveCell.Offset(0, 1).Columns("A:A").EntireColumn.EntireColumn.AutoFit
ActiveCell.Offset(44, 1).Range("A1").Select
End Sub

[Naveed Raza]

please use code tags while posting codes

try this code..

Please Login or Register  to view this content.

[Naveed Raza]

please use code tags while posting codes

try this code..

Please Login or Register  to view this content.

[aounhanif]

Aslamualaikum,


Thanks for helping me out with the formula. I tried the ocde but it has not worked what it does is this that after running the code it takes me to the YTD Balance sheet work sheet and to the cell A1 but it does not drag and coipy the formula. I have attached two more files to give you a better idea what I am trying to do.

Thanks in advance appreciate your help[

[Naveed Raza]

walekum assalam,

if possible could you please provide excel sample workbook its make very easy to resolve..

[aounhanif]

Aslamualaikum,

Please find the attachment. Please note that I would like to copy and drag formula from March to April to May and so on and when the macro is run it should only copy and paste date into the next month also I would like the command button to be created on 'Command Button Tab' and linked with macro. If you have any questions please ask

Jazak Allah.

[Naveed Raza]

now try this attached file and let me know if you have any question feel free to ask


hope this will work

[HaHoBe]

Hi, Naveed,

is there a special reason you get the value for LR but donīt use it furthermore but use EntireColumn instead?

Please Login or Register  to view this content.

Ciao,
Holger

[Naveed Raza]

Sure sir,

thank you so much for guiding me and helping me in making code in proper manner

once again thanks...