Delete row based on criteria

**D_N_L** · 11-04-2011, 07:34 AM

Morning all,

I have attached an example worksheet. Sheets 1 and 2 show you how my data is now.

To explain, based on the name column ('B') I would like the code to delete the ENTIRE ROW when a person only features on either sheet 1 or 2. In the attached the person called 'Jo' would be deleted from Sheet 1 because she only features on Sheet 1 and not Sheet 2.

So if a person is present on both sheets then they are left alone. The spelling of each name will always be correct but the list of names may be in different orders (as they are in sheet 1 and 2 in the example).

Thanks

ExampleForum.xls

**arlu1201** · 11-04-2011, 08:24 AM

Use this code - Since you have only mentioned delete from sheet1, i have not deleted row 2 from Sheet 2.

Please Login or Register  to view this content.

Thx to another fellow forum genius who had originally given me this code.

**D_N_L** · 11-04-2011, 09:04 AM

Thanks man!!! rep added.

**arlu1201** · 11-04-2011, 09:54 AM

Thank you....you can mark it solved if your issue is resolved.

**D_N_L** · 11-04-2011, 09:59 AM

tHIS IS SOLVED

**arlu1201** · 11-04-2011, 10:00 AM

Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save