Hi All,
First off sorry if this is in the wrong area!
I have been trying for hours now to get this to work and its doing my head in now. I have been all over google trying to get this to work but I just cant seem to get it.
I have some data on Sheet 2, and I want to display it on Sheet 1. On Sheet 2 the data starts at cell C2 then the next is in I2 then O2 etc (so every 6 cells but starting 3 Cells in.)
I want to show these cells on Sheet 1 for example B2,C2,D2. I have attached an example. I have tried all kinds of OFFSET, INDEX and other formulas but just cant get it. Any help would be great.
Thanks!
Bookmarks