I am currently working on a spreadsheet for managing the accounts of a small charity.

Each month people have a standing order set up to pay the charity account. Keeping on top of cancelled payments and people who have failed to set up the standing order is a nightmare.

There is a back log of data for about 2 years. I need to put in place a system using Excel and Access that can take all this data and split it into several different databases or spreadsheets.

For example taking all the data from a spreadsheet or a database, and producing a list of people to "chase up" a list of completed and on going standing orders and a black list of customers that want to cancel payments.

Can anyone help me out?