I need to have a way to fill columns with formulas that contain non-consecutive numbers. I don't want to have to type in each one, as I have 300 lines to fill.

Col A Col B Col C

Row 1 =Sales!E9 =Sales!O7 =CONCATENATE("00",Sales!A7,Sales!A4)

Row 2 =Sales!E12 =Sales!O10 =CONCATENATE("00",Sales!A10,Sales!A4)

Row 3 =Sales!E15 =Sales!O13 =CONCATENATE("00"Sales!A13,Sales!A4)


Hopefully the spacing comes out so people can make this out as top what it should look like.

I need to increase each formula by 3, instead of 1, due to spacing setup on the Sales page.

Also, I need to be able to maintain the A4 in the last formula, throughout the whole page. Any way to do that?

I'm working with Excel 2002, but am upgrading to 2007 in a week or two.

Thanks for any help.

Dan