Reference another cell, then copy it down through

[aryc_96]

hello all,

I am trying to reference another cell, then use addition to copy down through. For Example:

Sheet1 has values in cell A1 through A10.

I want to use those values on Sheet2, except every other cell ... use Sheet1!A1 in Sheet2A1, then use Sheet1!A2 in Sheet2A3, etc.

Can the cell reference formula use addition or any other formula?

Thanks

Michael

[NBVC]

In A1, enter:
=Sheet1!A1
in A2, enter:

=IF(A1="",INDEX(Sheet1!A:A,MOD(ROW(),2)+COUNT($A$1:A1)),"")

copied down.

[aryc_96]

I tried this and it works well ... with the exception that I need to put other info into the cells in between. That's why I wanted to try addition for the cell reference ...

sheet 2 cell A1 --- =sheet1!(A1)

sheet 2 Cell A3 --- =sheet1!(A1+1) jumps down 1 row on Sheet1

sheet 2 Cell A5 --- =sheet1!(A1+2) jumps down another row on Sheet1

sheet 2 Cell A7 --- =sheet1!(A1+3) jumps down another row on Sheet1

Similar to copying a pattern or formula.

[NBVC]

Without VBA not sure you can do that...

If your values to copy from other sheet are numbers and you want to insert text between.. then you can change the formula in A2, copied down and then just overwrite the cell you don't want the formula in with text... without affecting the cells that you do want formulas in.

e.g.

Replace A2 with:

=IF(ISTEXT(A1),INDEX(Sheet1!A:A,COUNT($A$1:A1)+1),"")

and copy down.

Now you can overwrite A2 with text, A4 with text, etc...