Hi,

Am Thu, 6 Jun 2013 20:44:41 +0100 schrieb dunndealpr:

Hey all, I use Excel 2007. Can it be set up to delete all rows in an
excel file when there is no value in a certain column? For instance,
every row with no value in column H would automatically be deleted?

filter column H for empty cells and delete the visible rows.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2