Morning Scott,

Without knowing the data is organized, I'm assuming in a table format, you
can use the Autofilter command under DataFilterAutoFilter. This is the
simplest and most straight-forward way of filtering what you want or don't
want in a table.

Good Luck,
Ron

"Scott MacLellan" wrote:

I have created an order form which has several worksheets for various product
lines. We are emailing these as an order form (several hundred line items).
When we get these orders back via email, we would like to be able to run a
macro to eliminate lines with no value thus leaving us with only the lines
with orders on them. Any help would be greatly appreciated!