WOT Excel Guru needed, Help me with a simple task that just can't figure out Options

[Porcharu]

I need to something really simple - but I can't figure out how to do it.
I want to use the autofill feature to increment a cell value by 2 like this
=Sheet2!C1
=Sheet2!C3
=Sheet2!C5
=Sheet2!C7
etc.
I need to use the autofill or something automatic or programmed becuase I need to do it for about 1000 cells several times. I have tried everything I can think of. I can probably use VB to program something up but I haven't done any programing for years and I really suck at it anyway.

Thanks

[Foster]

I need to something really simple - but I can't figure out how to do it.
I want to use the autofill feature to increment a cell value by 2 like this
=Sheet2!C1
=Sheet2!C3
=Sheet2!C5
=Sheet2!C7
etc.
I need to use the autofill or something automatic or programmed becuase I need to do it for about 1000 cells several times.

Hard to describe, easy to show, but I'll try.

Type your formula in 3 or 4 rows like you've shown.
Highlight the cells you just filled.
put your mouse on the little black box in the lower right corner of the selection you just made.
Hold down the left mouse button and drag down to as many cells as you want to fill.
Your selection box will grow and the formulas will be automatically incremented.
(heh heh, he said incremented (IMG:style_emoticons/default/aktion035.gif) )
You can do this in as many column as you like. Basically you just create the pattern and excel should recognize and repeat it. (IMG:style_emoticons/default/type.gif)

Hope this helps.