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

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
 

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

Top