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

**lukestkd** · 07-31-2012, 03:06 PM

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

**rvasquez** · 07-31-2012, 03:15 PM

Could you upload a sample of your workbook with before and after results?

Thanks!

**lukestkd** · 07-31-2012, 03:28 PM

Originally Posted by rvasquez

Could you upload a sample of your workbook with before and after results?

Thanks!

Added to original post

**rvasquez** · 07-31-2012, 04:05 PM

Could you provide before and after examples of what you are trying to achieve? I'm a hard time understanding what you are trying to accomplish by your post.