Change Positive to Negative

Hello, All.

I am trying to code to change certain numbers from positive to negative and vice versa based upon the value in column A (I have attached a worksheet to illustrate what I am about to describe).

I have a list of accounts in Column A.
I have a list of amounts in Column B.

I am trying to code a macro to look at Column A and perform the following:

If A = 28XXX then the value in Column B should be a negative value.

If A = 395XX then the value in Column B should change accordingly (if positive, make negative; if negative, make positive

Any assistance would be greatly appreciated!

Thank you in advance.

Give this a try:

Please Login or Register  to view this content.

Thank you for your quick response to my question. Everything worked very well!

Thanks again!