Menu

Macro - to copy duplicate rows to another sheet

Search this Thread

#1

Report Post

Don Guillett

Posts: n/a

Default

You don't have to sort to use autofilter.

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Hello,

I have unsorted data (and needs to stay unsorted, so no autofilters)
that I want to copy all duplicate rows into another sheet based on a
column value. Example:

A B C ...
1 x a a
2 z b b
3 x c c
4 y d d
5 z e e
6 r f f
7 x g g
...

Using column A as criteria for duplicates. There are 3 instances of x
and 2 instances of z that will need to be copied. Another worksheet
would then contain:

A B C
1 x a a
2 x c c
3 x g g
4 z b b
5 z e e

I have been looking at other macros that are prevalent in this
newsgroup that DELETE duplicate rows. However, I do not want to delete
anything. Since I do not know the # of times a particular value in the
column would be duplicated, I'm not sure a 2 FOR/LOOP type statements
ala bubble-sort type method would work?

Thanks,
-jzk

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Showing Duplicate Rows	EaglesNest	Excel Discussion (Misc queries)	4	March 26th 05 05:21 PM
Macro Errs when sheet is protected	Skankles	Excel Worksheet Functions	1	February 10th 05 06:44 PM
copy / paste selective rows	Kenny Kendrena via OfficeKB.com	Excel Discussion (Misc queries)	5	February 7th 05 12:55 PM
macro - adding rows to a column that is summed	HGood	Excel Discussion (Misc queries)	2	December 1st 04 03:28 PM
Macro, select Sheet "Number", NOT Sheet Name	DAA	Excel Worksheet Functions	4	November 30th 04 05:29 PM

All times are GMT +1. The time now is 08:48 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement