Excel 2003
 

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

Excel 2003
 

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

Excel 2003
 

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.

Here's one way using Excel 2003.

In my example, "another location" starts at cell O2. Column N is a helper
column.

In N2, put
=IF(AND(ISNUMBER(K1),K1=0),MAX($N$1:$N1)+1,"")

In O2 put
=IF(ROW()MAX($N:$N)+1,"",
OFFSET($A$1,MATCH(ROW()-1,$N:$N)-2,COLUMN()-15))

Extend O2 rightward to Y2.

Select N2:Y2 and extend downward for as many rows as needed.

Hide column N if desired.

Modify to suit.