removing rows

**glassonionsj** · 09-13-2007, 11:20 AM

I generate a sales report exported into excel that I need to remove rows including retail items. Is there a function that allows me to remove all rows containing 65451 in column B, for example?

**VBA Noob** · 09-13-2007, 12:07 PM

Without VBA try

Select Column B then Data Filter > Autofilter > select 65451 then highlight rows and delete

VBA Noob

**davidthegolfer** · 10-02-2007, 04:32 AM

Thanks VBA Noob, this was a useful reminder to me too.

David

**VBA Noob** · 10-02-2007, 04:38 AM

No problem

VBA Noob

removing rows

LinkBack

Thread Tools

Rate This Thread

Display

removing rows

Thank you

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions