I've copied data from a bank statement and pasted into Excel. But, the credit and debit values paste in the same [Debit] column; they need to be in two separate columns. Fortunately, each transaction description contains either the word "credit" or the word "debit".
Column C = Description
Column E = Debit
Column F = Credit
Is there a formula to search for the word "credit" in the description column and, if true, move the value in the debit column over to the credit column in the same row? If a VBA script is the answer, please provide detailed instructions. I do not know VBA at all.
Thanks
Column C = Description
Column E = Debit
Column F = Credit
Is there a formula to search for the word "credit" in the description column and, if true, move the value in the debit column over to the credit column in the same row? If a VBA script is the answer, please provide detailed instructions. I do not know VBA at all.
Thanks