Dynamic autofill VBA

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?

Hi
try this macro

this assumes that only cells K1 and K2 are populated in column K - there is no need to delete old values
is this correct?

Please Login or Register  to view this content.

Hope this can help in one or anoher way.

Thank you guys!

I actually used both of your solutions in my model, and both macros are helping me to do exactly what I wanted them to do! :-)