Results 1 to 19 of 19

Copy formula down column but need to skip 'n' rows

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Palmdale
    MS-Off Ver
    Excel 2007
    Posts
    9

    Copy formula down column but need to skip 'n' rows

    Hello!

    I have been looking around but have been unable how to figure my problem:

    I have two workbooks. One workbook serves as a tracker for dates while the other one uses the dates inputted in the first workbook to track futher information based on that date.

    When copying this formula I need to 5 rows skipped to pull in the correct - example below:

    D6='[662 Foundation Tracking.xls]Spread Footing'!$AR5
    D13='[662 Foundation Tracking.xls]Spread Footing'!$AR6
    D20='[662 Foundation Tracking.xls]Spread Footing'!$AR6

    but instead I am getting:

    D6='[662 Foundation Tracking.xls]Spread Footing'!$AR5
    D13='[662 Foundation Tracking.xls]Spread Footing'!$AR12
    D20='[662 Foundation Tracking.xls]Spread Footing'!$AR19

    Does anyone have idea on how to fix this?

    Thanks for any help.
    Last edited by wschultek; 01-27-2011 at 04:20 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