Cluelessonmacros
New Member
- Joined
- Mar 25, 2023
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I am clueless so any help is very much appreciated
I want to copy and paste multiple formulas from the last active cell
Column A will always have data dropped in
I want to copy formulas from H2 to Y2 from the last active cell in Column H to Y (this is because we remove the formulas on a lot of the data to preserve amendments and the data needs to go to to the end of the data in column A
I was trying autofill but it overwrites all the data already in and we manually amend some of this data later
Found a few things but not sure how to quite make it work (I have basic record and some basic amend knowledge on macros only I am a newbie!)
Any help is appreciated. Thank you
This is what I was thinking not sure how on track I am
I want to copy and paste multiple formulas from the last active cell
Column A will always have data dropped in
I want to copy formulas from H2 to Y2 from the last active cell in Column H to Y (this is because we remove the formulas on a lot of the data to preserve amendments and the data needs to go to to the end of the data in column A
I was trying autofill but it overwrites all the data already in and we manually amend some of this data later
Found a few things but not sure how to quite make it work (I have basic record and some basic amend knowledge on macros only I am a newbie!)
Any help is appreciated. Thank you
This is what I was thinking not sure how on track I am
Dim LastRow As Long |
Sheets("Sheet 1").Select |
LastRow = Range("A" & Rows.Count).End(xlUp).Row |
ActiveCell.AutoFill Destination:=Range("H2:Y2" & LastRow) |