Simple cell reference copying

[tallgingerbloke]

Hi,

I hope you can help. I have a workbook with data on one sheet and a sheet where all the data is brought together.
I want to reference a column of data from one worksheet and bring that information to the other worksheet. The difficult bit is that I want to add two blank cells between each row. This is to make room for the calculations I am doing on each row of data.

It is an mrp/forecasting spreadsheet so I need three rows, one for stock going out, one for stock coming in and one for the running total which will help with purchasing decisions.

So from the one line of data I am making three lines. This is fine until I try to drag and fill the copy formula down the page when it just copies the corresponding cell, it seems I cannot have my two spare rows,

Any ideas?

[tallgingerbloke]

...I have tried the fill series but that doesn't seem to work with formula