VBA - Filter based on E7 column E & delete rows not equal to E7

**nd4spd** · 07-12-2019, 08:42 AM

Hi, Please if one can hellp I am looking for VBA which will filter based on E7 being equal to column E lines and delete rows where column E not equal to E7. atached sample file.

Thank you

**PFDave** · 07-12-2019, 08:46 AM

Please Login or Register  to view this content.

This will do the job

**jindon** · 07-12-2019, 08:48 AM

Please Login or Register  to view this content.

VBA - Filter based on E7 column E & delete rows not equal to E7

LinkBack

Thread Tools

Rate This Thread

Display

VBA - Filter based on E7 column E & delete rows not equal to E7

Re: VBA - Filter based on E7 column E & delete rows not equal to E7

Re: VBA - Filter based on E7 column E & delete rows not equal to E7

Thread Information

Users Browsing this Thread

Similar Threads

Need a Macro to delete all rows containing values less than or equal 300 in column A

Delete Rows Based on Criteria Not Equal To?

Help!! How to delete rows based on value on 2 columns(same equal=0)

How to delete rows if column A1 and B1 are equal to A2 and B2

Delete rows based on cells that equal zero

Delete Rows Column F if greater than or equal to zero.

delete rows based on a filter criteria - VBA

Bookmarks

Bookmarks

Posting Permissions