Friday, April 1, 2011

Deleting Excel rows that have a specific blank column

A nice little bit of Excel macro magic allows you to delete rows if a particular column is blank.

I deal with data sets that are always scrambled, but usually in different ways.  This precludes the use of macro-scripting programs (like my personal favorite, trusty old Automate 4) because the patterns just different enough for pre-programmed key macros to fail.

Thanks to this little macro by Chip Pearson gets around the problem nicely.  Thanks, Chip!

No comments:

Post a Comment