Works but only once for 1 row. Should do the whole sheet in a single go.
Also the column F becomes blank (Cr/Dr goes away)
Type: Posts; User: robertdino
Works but only once for 1 row. Should do the whole sheet in a single go.
Also the column F becomes blank (Cr/Dr goes away)
Data in B2 should be combined with data in B1 with no space in between.
Then row 2 should be removed and lower row takes its place.
http://i.imgur.com/U0cVdQk.png
I have a bank statement with some entries like this.
As you can see, the description is split vertically into 2 cells in 2 different rows and the amounts/credit or...