Increment Formula

  • Thread starter Thread starter Mike Kiekover
  • Start date Start date
M

Mike Kiekover

I use the following formula to pull values from an external spreadsheet. If
I use the Auto-fill option to populate cells in the destination file it
copies the formula exactly. How can I get it to increment the last digit
when copying down a column


='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
Piping Line List Rev 0.xls]LINE LIST'!$AJ$7
 
Remove the last $
='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
Piping Line List Rev 0.xls]LINE LIST'!$AJ7

The 7 will now increment as you copy it
best wishes
 
I use the following formula to pull values from an external spreadsheet. If
I use the Auto-fill option to populate cells in the destination file it
copies the formula exactly. How can I get it to increment the last digit
when copying down a column

='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
Piping Line List Rev 0.xls]LINE LIST'!$AJ$7
Click to expand...

If you are talking about the #7 then all you have to do is remove the
$ sign. Try this:

='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN
2005044
Piping Line List Rev 0.xls]LINE LIST'!$AJ7
Click to expand...
 
I use the following formula to pull values from an external spreadsheet. If
I use the Auto-fill option to populate cells in the destination file it
copies the formula exactly. How can I get it to increment the last digit
when copying down a column
='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
Piping Line List Rev 0.xls]LINE LIST'!$AJ$7
Click to expand...

I think just need to change $AJ$7 to $AJ7. But I have never dealt
with external references.

FYI, you might want to change it to simply AJ7 if you want the
flexibility to also copy it across a row (e.g. changing AJ to AK etc).
 
piece-a-cake - thanks a bunch guys

Mike


joeu2004 said:
I use the following formula to pull values from an external spreadsheet.
If
I use the Auto-fill option to populate cells in the destination file it
copies the formula exactly. How can I get it to increment the last digit
when copying down a column
='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
Piping Line List Rev 0.xls]LINE LIST'!$AJ$7
Click to expand...

I think just need to change $AJ$7 to $AJ7. But I have never dealt
with external references.

FYI, you might want to change it to simply AJ7 if you want the
flexibility to also copy it across a row (e.g. changing AJ to AK etc).
Click to expand...
 
Back
Top