Select Data from a cell, move down a number, select data

Hi everyone,

I have a file that has about 2500 lines in it. The data is grouped into sections. Out of each section I need only two pieces of info. The data is consistent from group to group. My coworker and myself thought if we could pick the cell we want and then from there add 6 to the cell number then it would get what we wanted, but I can't figure out how to tell Excel to add 6 to the cell number to move down through the list. Attached is a jpg of a sample of my data. I need the data for NAME and INPUT.

Any hint and/or suggestions would be great.

Thanks,

Kage_

Hi kage,

This is certainly possible to do, but how do you want the results laid out? For example, are you storing each section's NAME and INPUT values in columns C and D? Or in one column with two cells for each section (C1 & C2, C3 & C4, etc.)?

Amended,

This was from post one request

Try

Please Login or Register  to view this content.

Returns B11, B17 etc


VBA Noob

As VBANoob pointed out, the OFFSET function will do what you need. Amended based on your secondary sheet request..

If Sheet1 holds your raw data, and you want results in Sheet2 starting in A2 & B2 (For Name and Input):

A2 formula:
=OFFSET(Sheet1!$B$12,(ROW(A1)-1)*6,0)

B2 formula:
=OFFSET(Sheet1!$B$14,(ROW(A1)-1)*6,0)

Fill downward to capture B18/B20 in A3 and B3, then B24/B26 in A4 and B4, etc.

This part of formula returns 0 for line 1, 6 for line 2, 12 for line 3.

So first cell will be B12 then B18 etc e.g looking 6 rows down

(ROW(A1)-1)*6

VBA Noob