|I am not sure if macros work on MACS as i have never tried. So an alternative method would be use a formula which will check if a value is lower than 0 and 'copy' that negative value to anothe column. |
I am not sure how we can MOVE that value, but atleast its a start.
1) Dolla values are in column 'A'
2) All negative values need to be copied/moved to column 'B'
So as the above shows the negative values have been copied to coulmn 'B'
in colum be you can use a formula such as:
You can then copy this down the 'B' column and all negative values in 'A' will be copied accross to 'B'
I know this isnt exactly what you asked for but i hope it helps.