creating an IF macro in Excel 2003

[Ronda]

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??

 

[Don Guillett]

yes

 

[Ronda]

I konw how to do the sort but when it comes to deleting just the data that
needs to be deleted how do I do that? The number of rows to be deleted will
always be different.

 

[Don Guillett]

It may be easier to just have you send your workbook to my address below
with a complete explanation and before/after examples.

 

[Gord Dibben]

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

 

[Ronda]

Thanks Don I will send that shortly. I will be away from my computer till
tomorrow after 8AM.

 

[Ronda]

Gord

I am working with another helper right now but if this does not cure the
issue I will get back to you. Thanks for the reply

 

[Gord Dibben]

I see you're working with Don G.

You're in good hands.


Gord