Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please.

So, I have created an excel sheet that collects exercise data into columns extending for several weeks.

In my data sheet I am trying to collect these data points into an organized table. I'll provide with an example to explain the issue:

Column A has the data at row 100. Column F has the next set of data at the same row, 100. This extends for 52 data points, each with a 5 column gap.

Essentially this 5 column gap between each data point makes it furiously hard to collect the data in the other sheet. I keep trying to use the (=sheet!X100), which works fine. But when i drag horizontally the increment only follows 1 column, not 5. Even if i select a series of 10 already referenced points excel cant seem to understand the sequence of rows. Naturally I've been grinding out this plotting each point manually, which at this point makes my eyes bleed as I have over 700 data points to plot...

Is there a way around this that I'm to stupid to see?

So, I have created an excel sheet that collects exercise data into columns extending for several weeks.

In my data sheet I am trying to collect these data points into an organized table. I'll provide with an example to explain the issue:

Column A has the data at row 100. Column F has the next set of data at the same row, 100. This extends for 52 data points, each with a 5 column gap.

Essentially this 5 column gap between each data point makes it furiously hard to collect the data in the other sheet. I keep trying to use the (=sheet!X100), which works fine. But when i drag horizontally the increment only follows 1 column, not 5. Even if i select a series of 10 already referenced points excel cant seem to understand the sequence of rows. Naturally I've been grinding out this plotting each point manually, which at this point makes my eyes bleed as I have over 700 data points to plot...

Is there a way around this that I'm to stupid to see?

Last edited by a moderator: