Is it possible to create an Excel VBA macro to move a negative value in one cell to another cell. For example, if a negative value exists in cell A1, move it to B1.
Ideally the macro would move the value as soon as it is entered into a cell. So if a negative number is typed in A1, it would be moved to B1 automatically and immediately.
I would like to say thank you in advance for any assistance.