Try DataFilterAutofilter


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 13:20:02 -0800, CarSum
wrote:

I have a master order sheet. I enter orders on this master daily. Not the
same items are ordered every day. I just want to print out the rows that
have items ordered on them without having to delete the blank rows??

Thanks in advance
Carol