should be pretty simple one. What I need is some sort of macro whic
searches my entire 5000 row spreadsheet between column A and R only an
completely removes the duplicate rows (i.e. deletes the row and shift
the others up). Duplicate rows could be any distance apart i.e. ro
300 and row 4500 so its not just a matter of comparing one row to th
next.

anyone

--
neowo
-----------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...nfo&userid=594
View this thread: http://www.excelforum.com/showthread.php?threadid=31439

Hi
as a starting point:
http://cpearson.com/excel/deleting.h...eDuplicateRows

"neowok" wrote:


should be pretty simple one. What I need is some sort of macro which
searches my entire 5000 row spreadsheet between column A and R only and
completely removes the duplicate rows (i.e. deletes the row and shifts
the others up). Duplicate rows could be any distance apart i.e. row
300 and row 4500 so its not just a matter of comparing one row to the
next.

anyone?


--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=314390