dvenn
08-29-2006, 12:37 PM
Looking for a method to delete rows from another sheet based of values the active sheet.
On 1 sheet (activesheet) I have Column A
1002
1992
43982
104432
3847
on another Sheet I have Column A
1002
1002
1002
104432
1002
104432
234
What I want is to look at the activesheet values, if the value is present in the other sheet delete that row (but delete every occurence).
This example the only row that should be left is the 234 Row
Sugestions?
On 1 sheet (activesheet) I have Column A
1002
1992
43982
104432
3847
on another Sheet I have Column A
1002
1002
1002
104432
1002
104432
234
What I want is to look at the activesheet values, if the value is present in the other sheet delete that row (but delete every occurence).
This example the only row that should be left is the 234 Row
Sugestions?