Hi, can anyone please help.

I have a workbook of data that we create each month. I love the feature when you get dynamic data of making the formulas auto fill down in cells next to those with data.

Is there any way of doing this in a standard workbook.

What i do is insert a column in the middle of the data, then put a formula in the first cell and have to drag down to the bottom to fil all the blanks.
As this is 15,000 records i wondered what the quickest way would be?

Thanks in advance

Paul