Macro help : Need a macro to delete rows that do not contain values >1 in columns O or P

**ostego** · 03-13-2014, 06:29 AM

So I am looking for a way to get a macro that will check if there are numbers equal to or above 1 in EITHER column O or column P.

If both of the cells in O and P are blank, then that row needs to be deleted.

If there is a value in column O or P that is 1 or over, then that column should be kept

Know this should be an easy one. Any help would be appreciated.

Thanks

**ragulduy** · 03-13-2014, 06:36 AM

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 03-13-2014, 06:40 AM

Maybe:

Please Login or Register  to view this content.

**sam51285** · 03-13-2014, 06:41 AM

Give a format..

**sktneer** · 03-13-2014, 06:44 AM

May be this.......

Please Login or Register  to view this content.

Macro help : Need a macro to delete rows that do not contain values >1 in columns O or P

LinkBack

Thread Tools

Rate This Thread

Display

Macro help : Need a macro to delete rows that do not contain values >1 in columns O or P

Re: Macro help : Need a macro to delete rows that do not contain values >1 in columns O or

Re: Macro help : Need a macro to delete rows that do not contain values >1 in columns O or

Re: Macro help : Need a macro to delete rows that do not contain values >1 in columns O or

Re: Macro help : Need a macro to delete rows that do not contain values >1 in columns O or

Thread Information

Users Browsing this Thread

Similar Threads

Macro to delete rows and columns

Macro to delete certain columns and delete rows based on time in another column

Macro to Delete Values if in both columns

Macro to delete certain rows and create columns

Macro to delete entire rows based values in columns

Bookmarks

Bookmarks

Posting Permissions