Hi,

I have a document where I every month collect a lot of data in columns A:J.

In column K, I have a formula which I want to autofill from cell K2 until the last row (row 1 are just headers..) The formula is already typed into K2.

The volume of data varies from month to month. So I want the macro to be dynamic.

If there is data from row 2 until row 50 I want the formula to be autofilled until row 50 only.

If there is data from row 2 until row 70, autofilled until row 70...

Any suggestions how to do this?