Thread: [Solved] Newbie needs help with Excel
View Single Post
 
Old 01-08-2015, 04:09 AM
Marchie Marchie is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Question Newbie needs help with Excel

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
Reply With Quote