Select range then copy rows macro

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
 
D

Don Guillett

a looping macro using data>filter>autofilter>filter by the group>copy to
WHERE???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top