Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select range then copy rows macro
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select range then copy rows macro
a looping macro using datafilterautofilterfilter by the groupcopy to
WHERE??? -- Don Guillett Microsoft MVP Excel SalesAid Software "noggins" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A macro to copy & paste many rows (a range) to the next column .. | New Users to Excel | |||
macro to select and copy rows only containing data | Excel Discussion (Misc queries) | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
Select always same Rows range | Excel Discussion (Misc queries) | |||
select a range, copy it to a new sheet | Excel Discussion (Misc queries) |