Excel 2007 : making a forumla skip 12 rows each time

**schu24** · 03-30-2011, 03:49 PM

Hi, I am in a bit of a pinch .... I have a formula

='Paste BDLD columns here'!C2

I need the next one to be C14, then C26.

The 'Paste BDLD columns here" is referencing another sheet.

How do I make a formula that will skip 12 lines each time without manually changing it.

Thanks!

**mrice** · 03-30-2011, 04:07 PM

Easy way to do this is two select the cell with the formula and the eleven cells beneath it. Then use the drag handle (bottom right of the selection) to copy down. The formula should only appear at the top of each block of twelve.