Fill down formula to last row-dynamic

[gazmoz17]

Hi,

Seen many threads on this with specific examples relating to posters data sheet e.g. specific range and required formula.

I want a macro button that fills down to last row regardless of what spreadsheet I'm in? So enter formula in for example (filtered list) A2 wish to then press a button which copies it down from A3 onwards. Either by dropping into A3 and triggering hotkey or after keyed formula in A2. However, dont want the code to ref A2 or A3 but be dynamic based on selection etc.

Many Thanks
Gareth

 

[LloydFinancials]

I created a macro/process that utilizes a hotkey.

Save this macro in an .xlsm workbook. Go to the Developer tab on the ribbon, select 'Macros.' Click on options, enter a capital K in the shortcut key. Hit OK and x out of dialogue box. Keep it open. Go to the workbook that has the formula you want copied down. Select the cell and hit shift + control + K.

Sub Macro2()
'
' Keyboard Shortcut: Ctrl+Shift+K
'
Dim a As Long
a = ActiveCell.SpecialCells(xlLastCell).Row
Selection.AutoFill Destination:=Range(Cells(ActiveCell.Row, ActiveCell.Column).Address & ":" & _
Cells(a, ActiveCell.Column).Address)
End Sub

Note: Last row is determined by the last formattable cell in the worksheet. Both workbooks need to be in the same Excel instance. Modify as needed.

 

[gazmoz17]

Thats cool mate thanks a lot