Copying fromula down have row desinatiion change by two rows instead of one

[petepro]

I'm trying to consolidate some information on a summary sheet. In A1 in my summary sheet I have the formula =Sheet1!A6. When I copy this formula down I need it to change to

=Sheet1!A8
=Sheet1!A10
=Sheet1!A12
=Sheet1!A14
=Sheet1!A16
etc

Is there a way to do this

 

[T. Valko]

I'm trying to consolidate some information on a summary sheet. In A1 in my summary sheet I have the formula =Sheet1!A6. When I copy this formula down I need it to change to

=Sheet1!A8
=Sheet1!A10
=Sheet1!A12
=Sheet1!A14
=Sheet1!A16
etc

Is there a way to do this

Try this...

=INDEX(Sheet1!A$6:A$100,ROWS(A$1:A1)*2-1)

Adjust for the correct end of range A$100.

 

[MickG]

Try:-

=OFFSET(Sheet1!$A$6,INT(ROW()*2),0,1,1)

Mick

 

[petepro]

Try this...

=INDEX(Sheet1!A$6:A$100,ROWS(A$1:A1)*2-1)

Adjust for the correct end of range A$100.

This worked perfectly!!!! Thank you so very much for your quick response.

 

[petepro]

Your index formula worked perfectly!! Thanks for your quick resonse

 

[T. Valko]

This worked perfectly!!!! Thank you so very much for your quick response.

You're welcome. Thanks for the feedback!

 

[Haldoug]

I know those formulas work, but if you enter in A1 of your summary sheet "=" and click on Sheet1!A2, and then in the next cell down enter "=" and click on Sheet1!A4, and then highlight these two cells, and click and drag or double click to fill the space you want is will autofill Sheet1!A6, Sheet1!A8, Sheet1!A10 and so on.

 

[Haldoug]

My bad, didn't work.