Combining multiple bank account data

[kbarton]

Hi

I'm trying to analyse the movement of funds between bank accounts scanned into Excel. I have attached a link to a sheet that explains this. Basically where a suspect has say 10 different bank accounts. I'm trying to show the transactions and movements of funds. A pivot table won't show the text descriptions such as Cash, Paid in by..etc.etc...so can't be used.

The link gives an idea http://cl.ly/380A361p2u0e39463s3N. The '10' accounts scanned into Excel are all on their own sheet, but need to be one sheet in date order to see at a glance the transactions onto and between accounts.

Many thanks for any help given.

Kev

 

[kbarton]

Hi Mick

I've transferred everything into Windows Excel to see if it's a MAC problem, but even though everything works ok and the column colouring work well, it still comes up one column short on the sorting. I can't understand why that should be. I've retyped some dummy data in from scratch to see if there's a formatting thing going on, but it's still coming up one column short for some reason. It's not putting the unsorted data in the gridlines so it's easy to see this side. I wonder what we have different?

Thanks again. Sorry to take up your Sunday... Very much appreciated.

Kev