Macro to convert value in Col E to a negative value where text "Balance"' is in Col A

[Howardc1001]

I have data that is imported


where Col A contains text "Balance" , the the value in the same row as Balance must be converted to a negative number


It would be appreciated if someone could provide me with the code to do this

[6StringJazzer]

It looks like you have a very simplified version of your data. I note that there are no formulas. If you have a formula in column E for the Balance, it will be converted to a value.

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help. The values are imported and have no formulas


Your code works perfectly

[6StringJazzer]

You're welcome!