Solved Move cells with a negative number

November 2, 2012 at 06:55:56
Specs: Macintosh
I download a spreadsheet which puts all dollar amounts in one column. I want to move all the negative numbers to an alternate column. Please help.

See More: Move cells with a negative number

November 2, 2012 at 08:01:59
✔ Best Answer
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'

A            B
 -10         -10
 -1500     -1500

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.

Report •

November 2, 2012 at 08:34:13
re: Macro's on a MAC.

Apple "reintroduced" VBA on the MAC's with Excel 2011.

2004 supported VBA
2008 did not
2011 does

See here for some history and comments:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question