Delete rows with Certain Criteria

**rizmomin** · 10-15-2013, 05:26 PM

Hello:

Please refer to attached sheet.
I have lots of employees with payroll info.

Some of the employees are inactive.
I like to VB Code to delete the row which has inactive employee info.
If Sum(D:I) = 0 for any given employee, then that is inactive.

In the attached sheet, Employee # 5, 6,10,13 and others are inactive and hence
those needs to be deleted.

Please let me know if any questions.

Thank you

Riz Momin

**hudibyk** · 10-15-2013, 05:39 PM

try this code

Please Login or Register  to view this content.

**rizmomin** · 10-15-2013, 05:47 PM

Hello:

I tried below code which i found in another thread and it works great.
Thanks.

Please Login or Register  to view this content.

**AB33** · 10-15-2013, 05:52 PM

Hi Riz,
A filter code would be faster, but this is another option

Delete rows with Certain Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Delete rows with Certain Criteria

Re: Delete rows with Certain Criteria

Re: Delete rows with Certain Criteria

Re: Delete rows with Certain Criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] how to delete delete rows with criteria and keeping formula

[SOLVED] Delete certain rows with criteria

[SOLVED] Delete certain rows with criteria

vba to delete rows if criteria not met

Delete rows with different criteria

Bookmarks

Bookmarks

Posting Permissions