Hi Guys,

I need you expert help please. Having a few issues in writing some script that will automatically drag down formulas next to some evergrowing data files. So to explain:


I have a 'sheet' where i am importing some data from a another source.
The headers are on row 3
There are 24 columns of data that are being imported. from column 'A' to column 'X'
Each time i import this data the number of lines will grow.


So what i really need from you guys is some script that will enable me to:

Drag some formulas down in cells 'Y4 to BB4' to the last line in the sheet. Everytime i record a macro using 'relative references' it is still refering to the last line number rather the ever growing list of lines of data.


Any help here guys would be greatly appreciated!

Thanks in advance

Regards

Nick