oska
01-05-2015, 06:19 PM
Hi,
I have a worksheet (in Excel 2010) which I update weekly and that I want automate the update process with a macro. Basically I fill down the latest data which is on a weekly basis by adding a new row (all cells contain a formula or are blank). I have done this manually by using keyboard shortcuts and recorded a macro as I've done it. Here is the macro:
Sub filldown_sheet()
'
' filldown_sheet Macro
' fill down/update datastream data
'
'
Range("B7").Select
Selection.End(xlDown).Select
Range("A1102").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Range("A1102:P1103").Select
Selection.FillDown
End Sub
This works fine except the range doesn't automatically/dynamically update. how can I do this so it automatically changes to select the most recent data i.e. dynamically update?
many thanks
I have a worksheet (in Excel 2010) which I update weekly and that I want automate the update process with a macro. Basically I fill down the latest data which is on a weekly basis by adding a new row (all cells contain a formula or are blank). I have done this manually by using keyboard shortcuts and recorded a macro as I've done it. Here is the macro:
Sub filldown_sheet()
'
' filldown_sheet Macro
' fill down/update datastream data
'
'
Range("B7").Select
Selection.End(xlDown).Select
Range("A1102").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Range("A1102:P1103").Select
Selection.FillDown
End Sub
This works fine except the range doesn't automatically/dynamically update. how can I do this so it automatically changes to select the most recent data i.e. dynamically update?
many thanks