Samanthad2007
New Member
- Joined
- Aug 12, 2020
- Messages
- 2
- Office Version
- 2016
- 2013
- Platform
- Windows
I want to have the reference cell in the offset function to be the 2nd row of the last used column. I want to have a macro that adds 3 formulas based on where this last column is. For example, my last column right now is DG and when I run the macro, I want it to add 3 formulas in cells DH2, DI2, DJ2. Then the next time I run the macro, I want it to add the formulas in cells DK2, DL2, and DM2.