So for an early stab at VBA I'm writing a macro:
- I'm pasting in a set of data that increases in numbers of rows each month; data is well organised with no blank values/columns
- I have formulae in columns A-L and my data is dropped into columns L-onwards
- I want to update formulae/columns in A-L to fill down to match the last value in column M
Struggling so if you are able to help with an explanation that would be really appreciated. I know it involved selecting the last row in the A:L - I've got that but I can't work out how to cleanly fill down to match a varying length column M each time.
Sub Macro6() ' ' Macro6 Macro ' ' Range("M1").Select Range(Selection, Selection.End(xlDown)).Select ActiveCell.Offset(0, -1).Select Range(Selection, Selection.End(xlToLeft)).Select Range(Selection, Selection.End(xlUp)).Select Selection.FillDown End Sub