Originally Posted by Lourie
I need to change a positive value to become negative value in Excel 2007 and then move the value two cells to the left. This I need to do selectively and repeatedly in a spreadsheet. I create a macro to do this but it does not work as it should.
In the cell 2 columns to the left you could type in the formula:
...(assuming D2 is where the number is) and copy & paste this down, but if you want it to be selective, I'll need a bit more info on what the criteria is to be of any more use to you.