+ Reply to Thread
Results 1 to 4 of 4

Increase row of cell reference to another worksheet by 20

  1. #1
    Registered User
    Join Date
    10-24-2006
    Location
    Texas
    Posts
    4

    Increase row of cell reference to another worksheet by 20

    Cell 'G7' of 'Sheet1' contains '=Sheet2!F17'. I would like for
    .....'G8' ...........................'=Sheet2!F37', and
    .....'G9'............................'=Sheet2!F57', etc.
    Each time the row of 'Sheet1' increases by 1, the row of 'Sheet2' increases by 20.

    Any help is greatly appreciated.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    in cell G8 type following :
    =OFFSET(Sheet2!$F$17,20*(ROW()-ROW($G$7)),0)
    and copy down ...

    Hope it 's working OK ...

    Cheers
    Carim

  3. #3
    Registered User
    Join Date
    10-24-2006
    Location
    Texas
    Posts
    4

    Worked like a charm

    Thanks for your help.

    You saved me countless hours.

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Glad I could help ...

    Thanks for the feedback

    Carim

+ 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