Increment Formula

[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

 

[Bernard Liengme]

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

 

[Gord Dibben]

Mike

Get rid of the $ sign in $A$7

Should read $A7


Gord Dibben MS Excel MVP

 

[Mark]

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

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

 

[joeu2004]

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

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).

 

[Mike Kiekover]

piece-a-cake - thanks a bunch guys

Mike

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

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).