ali

Recorded macro.....

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/14/2003 by Gord Dibben

Sheets.Add
''inserts a sheet and copies unique rows to A1 on new sheet
Sheets("Day").Range("C1:H500").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("A1"), Unique:=True
End Sub

Gord Dibben Excel MVP


On Sun, 14 Dec 2003 16:21:04 -0600, ali
wrote:

Tom, apologies for missing your question. In response, i am only
interested if the whole row matches another.

In response to the suggestion to use macro recorder and advanced
filter... when i tried it the advanced filter part was not recorded.
Is this normal?

Thanks for all the help


---
Message posted from http://www.ExcelForum.com/