You would need to define the range you want to sort so that it includes all
of the columns and rows that contain data which you want kept tied to the
dollar value.

Then you would use the Sort method to sort that defined range, making the
column (or row, depending upon which you are sorting) that contains the data
to be sorted first as Key 1. You can have additional keys but I doubt that
you need them for this execise. You also can set a parameter for ascending
or descenting order. I would think that ascending would be appropriate for
your purposes.

Then you would need a loop to look at the values and for each value that
equals 0.00, you can delete it, or copy it and paste it somewhere.

That's about it.


"Jen_T" wrote in message
...
How would I set up a macro for a worksheet that varies in number of rows
daily, to sort a by dollar amount. Than for any dollar amount that equals
$0.00 I would need to have those rows moved to another worksheet within
the
same workbook and than have specific columns removed from the new
worksheet.
Is this possible ?