Results 1 to 4 of 4

Formula to move selection three cells to the right in a different sheet

Threaded View

lukestkd Formula to move selection... 07-31-2012, 03:06 PM
rvasquez Re: Formula to move selection... 07-31-2012, 03:15 PM
lukestkd Re: Formula to move selection... 07-31-2012, 03:28 PM
rvasquez Re: Formula to move selection... 07-31-2012, 04:05 PM
  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Formula to move selection three cells to the right in a different sheet

    I have a sheet (studentview) which finds values from a row in another sheet (homework). It is picking up percentages, which are located at every third column on a row. When I extend the formula right, instead of continuing the pattern of three columns (C11, F11, I11, L11 etc), it goes to the very next column,

    Is there a formula I can use that will select the cell three cells to the right of the previous selection OR is there a tool I can use to do this?

    i.e. if B11 of the studentview sheet shows the value of C1 in the homework sheet, I then need B7 to show F11, and B8 to show I11.

    I have nearly 100 seperate percentages to use, so manually won't work.

    Thank you in advance! Luke

    GCSE Marks v08 Aladin.xlsm

    GCSE Marks v14.xlsm
    Last edited by lukestkd; 08-01-2012 at 04:38 AM.

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