If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dena320" wrote in message
...
I have a spread sheet with info in columns A-K. Column K is the Balance
column. I am trying to sort out all of the 0.00 figures in the Balance
column and move the info from columns A-K with a balance of 0.00 to
another
location on the spreadsheet. I know I can sort or filter the 0.00 balance
but don't know how to automatically copy the data in the whole row to
another
location.

Thank you,
--
Dena320