How to use Offset function when the reference cell changes?

[Samanthad2007]

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.

 

[CA_Punit]

Is it necessary to do with a macro. It can be done through formula also.. Getting the last column can be done throgh formula also