View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
D[_6_] D[_6_] is offline
external usenet poster
 
Posts: 34
Default Automatically Cut Row of Data and Paste to Other Sheet?

Hey guys-
You have all been soo wonderful about helping me out on the other issues- I
decided to throw this one at you...

I have searched newsgroups, this forum, etc, and see references to this, but
not to do exactly as I need done. So maybe someone can throw me in the right
direction here...

I have a column of numeric values. IF the cell value is negative or less
than zero, I want the entire ROW that it sits on cut and pasted onto the
worksheet named 'Check Status' within the sale file. This row(s) would be
pasted to the first available cell on that sheet. I would like this all done
automatically. How do I do this?
Thank you soo much in advance!
D