Dear all,

I havew a spreadsheet in wich one sheet constantly grows (feed from outside software) and i would like another sheet to run a formula on this data.
How ever , i never know how long will the list grow.

I would like in other words.. to grow the colomn with the formulas to the same size of the column that keeps on growing.

is it possible?
if not , is there VBA module for that ?

thank you