Referencing cells in consecutive rows
 

Hello, this is my first post to the forum and I am hoping someone would be willing to offer some advice...

This is a difficult question for me to put into words but I am trying to find a way to reference a cell on another sheet in two consecutive rows and then skip to the next row.

Here is an example and what I am looking for:

=Sheet1!A1
=Sheet1!A1
=Sheet1!A2
=Sheet1!A2
=Sheet1!A3... etc, etc.

I am currently using an absolute reference, copying it down 3 cells, then manually changing the last cell to reference the next in line. Is there a faster way to do this? I have to do this hundreds of times and it would be a real timesaver.

Thank you in advance!

Referencing cells in consecutive rows
 

Hi,

Am Wed, 10 Jul 2013 16:31:00 +0100 schrieb PVermillion:

=Sheet1!A1
=Sheet1!A1
=Sheet1!A2
=Sheet1!A2
=Sheet1!A3... etc, etc.

try:
=INDIRECT("Sheet1!A"&ROUNDUP(ROW(A1)/2,0))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

This is exactly what I was looking for! Thank you very much!