Results 1 to 9 of 9

How to increment an absolute cell reference

Threaded View

acharletta How to increment an absolute... 01-05-2013, 05:53 PM
Moo the Dog Re: How to increment an... 01-05-2013, 06:23 PM
acharletta Re: How to increment an... 01-05-2013, 06:43 PM
acharletta Re: How to increment an... 01-05-2013, 06:45 PM
Moo the Dog Re: How to increment an... 01-05-2013, 07:14 PM
acharletta Re: How to increment an... 01-06-2013, 06:46 PM
Tony Valko Re: How to increment an... 01-05-2013, 07:27 PM
Moo the Dog Re: How to increment an... 01-06-2013, 07:20 PM
acharletta Re: How to increment an... 01-06-2013, 08:03 PM
  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    7

    How to increment an absolute cell reference

    I am trying to increment an absolute cell reference in an Excel spreadsheet column.

    What I want to be able to do is increment the absolute cell reference by 7 reslutling in increasing each row number by 7 starting with

    ='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$5

    resulting in the following concecutive rows

    ='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$12
    ='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$19
    ='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$26

    etc.

    I have multiple rows and columns. Any ideas would be appreciated.
    Last edited by acharletta; 01-05-2013 at 06:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1