command button vba to copy formula from cell above

[KK1234]

Hi,
I have sheet1 having two formulas.
Ideally I can copy and paste the formula to the entire column,
However this then populates , say 3000 cells unnecessarily which slows down excel performance or increases size of the file.

I am looking for a vba ( this is used to open userform)
To include copy formula from filled cell above to next empty row
( cells will be in column K & L)

So every-time userform is opened, the formula is copied to next empty row.

Any help please

kind regards

Please Login or Register  to view this content.

[Tinbendr]

something like

Please Login or Register  to view this content.

[KK1234]

Hi Tinbendr,
Thanks for your reply.
I tried the code , but it does not seem to work.
May be I am making a mistake somewhere.

The formula I am using are ( in K say row 9)

Please Login or Register  to view this content.

In L ( say in row 9 again)

Please Login or Register  to view this content.

Can you guide me further please.
I have clicked * to thank you for offering me your valuable help.
Kind regards

[Tinbendr]

Uhhh, OK, plan B

Please Login or Register  to view this content.

[KK1234]

Hi TinBendr,
Perfect solution.
Much appreciated.
Once again thanks for a great solution.
Kind regards