Combine multiple sheets

[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.

I need the data to show the transactions each day across multiple bank accounts visually. I am able to scan bank statements into Excel, the problem is showing any number of statements on one sheet to show the transactions on each day.

Many thanks for any help given.

 

[VoG]

This may help you http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

[kbarton]

Thanks for your response. The macros are useful, but what I need to achieve is for the date to be as follows:

Account 1 Account 2 Account 3
Transaction Credit Debit Credit Debit Credit Debit
1/1/2011 Cash 5000
2/1/2011 Transfer 6000 6000
3/1/2011 Dir Debit 250
4/1/2011 Bill Payment 500


This data will come from individual sheets which are scanned copies of bank statements. Although I could get this data into one sheet, I need to be able to keep the accounts in multiple column format to be able to identify the transfers between accounts and movement of funds.

Hope this is clearer.

Many thanks for your help.

Kev