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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top