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

yes

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ronda" wrote in message
...
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??

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" wrote:

yes

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ronda" wrote in message
...
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??

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ronda" wrote in message
...
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" wrote:

yes

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ronda" wrote in message
...
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??

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

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

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ronda" wrote in message
...
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" wrote:

yes

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ronda" wrote in message
...
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??

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" wrote:

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

I see you're working with Don G.

You're in good hands.


Gord

On Thu, 11 Dec 2008 07:21:00 -0800, Ronda
wrote:

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" wrote:

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