I Have a spreadsheet of data exported from another system as csv file and then opened in excel, Column A contains transaction type and Column M equals transaction Value. The problem is that there is no sign on the transaction so debits and credits both show in column m as positive. I want a macro which can look at col A and if it equals PA value in col M = (Value *-1).
A simple formula will do that. =IF(A2="PA",M2*-1,M2) copied down
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry Glenn putting in the formula overwrites the current value and therefore changes value to 0. I need a temp variable to hold the cell value whilst applying the formulae but not sure how to code this.
You cant have a formula and a value in one cell. I'd intended thst you use it in the first empty column.
Sorry I wasn't clear I can't add any columns as the data is needed again with only the same no of columns, hence the need for macro,
OK. Understood. I'm hopeless with macros. Over to others...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks