I'd like a macro that will delete from Worksheet 1 duplicated rows of data found on Worksheet 2. For instance, it would work like this. WorkSheet 2 contains 4 columns of several rows of data. WorkSheet 1 contain an indefinite numbers of rows made up of 6 columns of data. If any row on WS 1 (6 col's) contains any 4 col's of data found on WS 2, the entire associated row on WS 1 will be deleted regardless of sequence. Example:

Worksheet 1

A B C D E F
1 Jones, Carter, Wright, Brown, Fredricks, McGee
2 Franklin Hansen, Mays Franks Foster Martin
3 Underwood, Parker Jamison Ford Donner Clark

Worksheet 2
A B C D
1 Hansen, Franklin Martin Foster
2 McGee Brown Jones Morrison
3 Underwood, Parker, Brown, Fredricks
This would be the effect to WS 1:

A B C D E F
1 Jones, Carter, Wright, Brown, Fredricks, McGee
2 Underwood, Parker Jamison Ford Donner Clark
(Row 2 on WS 1 was eliminated because it duplicated 4 members from one row.
Row 1 was left intact. Row 3 was left intact because eventhough it contained 4 members from the list, it did not, on the other hand, match 4 members from any one row on WS 2 )