i have a workbook with several spreadsheets. in each row on each spreadsheet
there is a sku, upc, description, empty cell to enter floor count (we'll call
this A), empty cell to enter backroom count (we'll call this B), empty cell
to enter system count (we'll call this C), cell that automatically calculates
the difference between the system count and the combined totals of floor and
backroom counts (D= C-(A+B)).

what i need it to do is- if D is more or less than 0, i want that whole ROW
copied to a blank spreadsheet at the end of my workbook. so far, i have only
been able to get it to copy the first cell from that row, but i need the
whole thing. is there a way to do this other than putting a formula in each
row in that column??? thanks, i hope i explained this well.