+ Reply to Thread
Results 1 to 3 of 3

Increase Linked Cell Formula

Hybrid View

  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    11

    Increase Linked Cell Formula

    How can I increase a cells forumula reference cell by 30 each time it's dragged down.
    For example
    =('Santee EMC'!$A1) is in A1 on Summary Page
    =('Santee EMC'!$A31) is in A2 on Summary Page
    =('Santee EMC'!$A61) is in A3 on Summary Page.

    etc..

    I have been pulling my hair out over this all night and know it's something simple! Help?
    Last edited by Nunzii; 01-11-2011 at 10:31 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Increase Linked Cell Forumla

    I know somebody will come along with something smarter, but this is all I can think of right now.

    =INDIRECT("'"&$C$1&"'!$A"&B1)

    B1 = 1
    B2 =B1+30
    drag down

    C1 = Santee EMC
    HTH
    Regards, Jeff

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Increase Linked Cell Forumla

    Hi Nunzii,
    In A1 put
    =('Santee EMC!$A" &(ROW()-1)*30+1
    and drag down.

    I've been writing code all day so the above may not work in a formula.

    In A1 the (ROW()-1)*30+1 will give the 1,31,61 etc
    Then you may assemble the numbers along with the Santee EMC!$A
    and then do an indirect. of the appended string.
    Last edited by MarvinP; 01-11-2011 at 10:04 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

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