Auto Assign Neg# To Corresponding Cell When Neg# Is Found In Column

[jessekanclerz]

Does anyone know a macro (or function) that will look for a negative number in one column and append a negative sign to a corresponding column?

For instance, my spreadsheet looks like:

Company | Cust# | SaleDate | Frequency | SaleAmt
1 100 2/6/2008 1 108.6
1 100 3/6/2008 1 142
1 100 3/7/2008 1 -142
1 100 3/9/2008 1 200

When a negative number is discovered in column E4, a negative will be assigned to the corresponding number in cell D4.

Thanks,

Jesse

[NBVC]

A non-macro way to do it is to use a temporary helper column, say column F....

=if(E2<0,-D2,D2) copied down

Then select column F and copy it, go to D1 and go to Edit|Paste Special and select Values.. Click Ok.

Now you can delete the temporary F column...

[jessekanclerz]

That did the trick. Thanks a lot!