Increment Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Kiekover - 07 Mar 2007 23:15 GMT

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

Signature

Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Bernard Liengme - 07 Mar 2007 23:30 GMT

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

Signature

Bernard Liengme
http://people.stfx.ca/bliengme

>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
[quoted text clipped - 3 lines]
> ='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
> Piping Line List Rev 0.xls]LINE LIST'!$AJ$7

Reply to this Message

Gord Dibben - 07 Mar 2007 23:35 GMT

Mike

Get rid of the $ sign in $A$7

Should read $A7

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 3 lines]
>='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044
>Piping Line List Rev 0.xls]LINE LIST'!$AJ$7

Reply to this Message

Mark - 08 Mar 2007 01:05 GMT

> 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
[quoted text clipped - 6 lines]
> --
> Posted via a free Usenet accoun t fromhttp://www.teranews.com

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

Reply to this Message

joeu2004 - 08 Mar 2007 01:07 GMT

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

Reply to this Message

Mike Kiekover - 08 Mar 2007 15:45 GMT

piece-a-cake - thanks a bunch guys

Mike

>> I use the following formula to pull values from an external spreadsheet.
>> If
[quoted text clipped - 9 lines]
> 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).

Signature

Posted via a free Usenet account from http://www.teranews.com

Reply to this Message