Hello All,
I have 4 columns of data always starting in column C
but can exist on any number of rows. The columns are
headed as the sample below.
There is always data above and below my data block
which can push my block up or down in column C.
How do I extract just the last 2 columns E and F and
copy the contents to cell S1 when the number of rows
is not fixed.
I would appreciate any help to do this please. I've
managed to get the headings but don't know how to
cope with the variable rows.
Thankyou in advance.
Regards,
RC
Column C ColD ColE ColF
OptionsName Avg Pos Neg
Slimsen J 6.6 10.2 2.7
Campbell C 7.8 6.4 1.7
Louis N
Leuwis P 3.8 3.6 1.3
Hoover B 14.6 13.6 4.1
Preen T
Bester S 15.3 22.4 5.7
Bosten G 3.2 3 1.3
Jareete H 24.9 28.9 5.7
Barton W 26.6 36.8 11.3
Astors B 8.9 9.8 3.1
Williams M 18.4 27.4 8.1
I have 4 columns of data always starting in column C
but can exist on any number of rows. The columns are
headed as the sample below.
There is always data above and below my data block
which can push my block up or down in column C.
How do I extract just the last 2 columns E and F and
copy the contents to cell S1 when the number of rows
is not fixed.
I would appreciate any help to do this please. I've
managed to get the headings but don't know how to
cope with the variable rows.
Thankyou in advance.
Regards,
RC
Column C ColD ColE ColF
OptionsName Avg Pos Neg
Slimsen J 6.6 10.2 2.7
Campbell C 7.8 6.4 1.7
Louis N
Leuwis P 3.8 3.6 1.3
Hoover B 14.6 13.6 4.1
Preen T
Bester S 15.3 22.4 5.7
Bosten G 3.2 3 1.3
Jareete H 24.9 28.9 5.7
Barton W 26.6 36.8 11.3
Astors B 8.9 9.8 3.1
Williams M 18.4 27.4 8.1