Hi Excel gurus, I have an excel spreasheet where I need a VBA script which does the following
1. Column E, if cell = text "Credit Memos" or "Payments" or "Return", then;
2. Column G, Convert the value to negative, basically doing value x -1
sample file attached
Thank a lot.
Cheers
Bookmarks