| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Threaded Mode
