View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sojo Sojo is offline
external usenet poster
 
Posts: 21
Default find and move values <0

I am writing a macro to automate several processes. I have the following
table where column A has positive and negative values and column B is blank.
I need a formula that will find all the negative values in column A and move
them to column B. In essence, it needs to say if number in column A < 0,
then cut it and paste it into column B.

A B
1. Original Negative
2. 3.72545
3. 3.4584
4. 3.1071
5. -0.460399
6. -0.803222
7. -1.12457