How is the data "pulled"? By formulas?

If the cells contain formulas that return "" is that to be considered as
blank?

One column or more columns?

If more than one, which to sort on?

Which column would not have some data?

By "no data" do you mean in the entire row or just in one or some of the
columns?

Assume we can't see your worksheet and start from there.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 13:01:03 -0800, Ronda
wrote:

I am creating a new worksheet that will be an order form for my supplier. the
information input on the worksheet will pull from an existing worksheet.
After all the information is entered in the new worksheet I need to create a
macro that will sort and delete rows based on weather or not there is data in
the cells. The sort and delete will be different on every order. Can a macro
do this??