N
noggins
Hi
I have a list of data and want a macro to identify groups of rows with
the same value in Col A, then select this range (Col A:C) and copy it
into a new sheet.
The receptors are grouped and will not be repeated later. There will
be thousands of receptors, therefore to make this run quickly i want
it to select group R1, and copy them. Then, i want to do R2, then R3
etc. Ideally the macro will remember how far down the list it had got
to and restart from that point.
See example below:
RcptNo LinkRef Distance
R1 1 10
R1 2 20
R1 3 30
R2 1 10
R2 2 30
R2 3 20
R3 1 10
R3 2 40
R3 4 100
All help much appreciated!
N
I have a list of data and want a macro to identify groups of rows with
the same value in Col A, then select this range (Col A:C) and copy it
into a new sheet.
The receptors are grouped and will not be repeated later. There will
be thousands of receptors, therefore to make this run quickly i want
it to select group R1, and copy them. Then, i want to do R2, then R3
etc. Ideally the macro will remember how far down the list it had got
to and restart from that point.
See example below:
RcptNo LinkRef Distance
R1 1 10
R1 2 20
R1 3 30
R2 1 10
R2 2 30
R2 3 20
R3 1 10
R3 2 40
R3 4 100
All help much appreciated!
N