autofill with dynamic lists
 

I have a dynamic recordset inported from a database.
At the end of this I have a formula that calculates both values
from this recordset and values in ánother sheet.
If i aoutofill this column manually all the way down.
excell remembers how many records i had. And when i upodate the list
I can not use the formulas below.

Is there a way to make this work automaticly?

autofill with dynamic lists
 

how are you updating the list?
With VBA you can paste the records then paste the formulas in the following
row.

Please provide more information

"Pontus SWE" wrote:

I have a dynamic recordset inported from a database.
At the end of this I have a formula that calculates both values
from this recordset and values in ánother sheet.
If i aoutofill this column manually all the way down.
excell remembers how many records i had. And when i upodate the list
I can not use the formulas below.

Is there a way to make this work automaticly?