Hi, i am looking to drag my calculation across cells in excel.
I have a two page set up.

Calculation in cell 1, sheet 1 = 4 cells across on sheet 2

I want to drag the formula across my cells on sheet 1 so that

Cell 1 sheet 1 = Sheet 2 Cells 1 - 4
Cell 2 Sheet 1 = Sheet 2 Cells 4 - 8
Cell 3 Sheet 1 = Sheet 2 Cells 9 - 12 etc...

also

Cell 10 Sheet 1 = Sheet 2 cell 4
Cell 11 Sheet 1 = Sheet 2 cell 8
Cell 12 Sheet 1 = Sheet 2 cell 12 etc...

This would make things alot easier, REALLY dont want to have to do these by
hand 1000 times :)

Hope some one can help.

Thanks Giddy