increase a cell reference by increments greater than one...
 

Hi,
We are makinga purchase order sheet that will contain may PO's. We would
like to summarize the ata on another sheet.
Each cell we need to reference is 37 cells from the previous, is there a way
to populate the references without had typing "=Sheet2!A1" "=Sheet2!A38", etc?
Thank you,
Gary

One way

=OFFSET(Sheet2!$A$1,ROW(1:1)*37-37,)

copy down

Regards

Peo Sjoblom

"Gary Fuller" wrote:

Hi,
We are makinga purchase order sheet that will contain may PO's. We would
like to summarize the ata on another sheet.
Each cell we need to reference is 37 cells from the previous, is there a way
to populate the references without had typing "=Sheet2!A1" "=Sheet2!A38", etc?
Thank you,
Gary

I hope we may add a post saying thank you.
Gary

"Peo Sjoblom" wrote:

One way

=OFFSET(Sheet2!$A$1,ROW(1:1)*37-37,)

copy down

Regards

Peo Sjoblom

"Gary Fuller" wrote:

Hi,
We are makinga purchase order sheet that will contain may PO's. We would
like to summarize the ata on another sheet.
Each cell we need to reference is 37 cells from the previous, is there a way
to populate the references without had typing "=Sheet2!A1" "=Sheet2!A38", etc?
Thank you,
Gary