S
SYBS
I have a worksheet with up to 60 names in col A, called “AERIAL RESCUEâ€
Each name is allocated 7 rows for different types of data entry. As below
A……… J Q
R7 20
R8 32
R9 33
R10 62
R11 38
R12 29
R13JONES 345 1
R14 56
R15 75
R16 95
R17 23
R18 43
R19 32
R20SMITH 26 6
I need to extract the data from Col J & Col Q to use in a summary sheet
in the same workbook, called IND RESULTS. There could be up to 60 sets to
extract and they fit in to the scheme below. Each Name on this sheet is
allocated 36 Rows for their summary and the sheet contains all the summaries
of all the names, one after the other.
A ………..D F
R1 to
R11 OTHER DATA
R12 20
R13 32
R14 33
R15 62
R16 38
R17 29
R18 345 1
R19 to
R36 OTHER DATA
R37(next name and summaries in following 36 rows)
I have tried all sorts of loops and ranges etc, but not getting anywhere at
all. Can anyone please help ?
Each name is allocated 7 rows for different types of data entry. As below
A……… J Q
R7 20
R8 32
R9 33
R10 62
R11 38
R12 29
R13JONES 345 1
R14 56
R15 75
R16 95
R17 23
R18 43
R19 32
R20SMITH 26 6
I need to extract the data from Col J & Col Q to use in a summary sheet
in the same workbook, called IND RESULTS. There could be up to 60 sets to
extract and they fit in to the scheme below. Each Name on this sheet is
allocated 36 Rows for their summary and the sheet contains all the summaries
of all the names, one after the other.
A ………..D F
R1 to
R11 OTHER DATA
R12 20
R13 32
R14 33
R15 62
R16 38
R17 29
R18 345 1
R19 to
R36 OTHER DATA
R37(next name and summaries in following 36 rows)
I have tried all sorts of loops and ranges etc, but not getting anywhere at
all. Can anyone please help ?