Hi this is my first post on the forum and I'm new to Excel.
I have just taken over as treasurer of our club and thought I would do the accounts using MS Office 2010.

I've a set of excel worksheets for each month.
One showing Income and one expediture.
On the expenditure sheet I have columns for: Date, Description, Cash, Cheque, Amount and Cheque Number.

What I want to do is, create another worksheet that picks out only the rows that have Cheque in and displays "Date, Description, Amount and Cheque Number.


This will make it easier to compare the cheques that have been banked against the the cheques that have been written. Rather than having to search through each month.

Any help would be great