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

Hi and welcome.

Before going through all the pains of creating an accounting system from scratch, have you searched the Net?
There are numerous free and usable examples out there which have already been tried out and can be used for small scale accounting.
Cheers

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer.
Yes, look on the net but could not find one that fitted our needs, so worked from cratch.

I completely agree with PF. There are online check registers that you can use. They are free and on the cloud so you can do your work from any computer or even your tablet. Even more so since you are new to Excel. This is like reinventing the wheel when you haven't even learned how to chop wood yet.

Here's one...
https://www.clearcheckbook.com/

I thought the idea of a this forum was to help newcomers to Office, that's why I signed up so I could learn.
It seems I was wrong

Don't take offense at what I said. I was trying to be funny. But really this forum is generally used by folks who have at least a working knowledge of Excel and have a specific problem.

This is a great place to learn. But I don't think you're going to be able to learn all you need to work up an accounting spreadsheet from scratch all that quickly.

Personally, I've been using Excel for 30 years and I'm still learning.

If this is what you really want to do, why don't you attach a sample of what you have so far. That will really help us help you.

No offence taken Gebobs.
I've attached a copy of the account spreadsheet I created.
As you will see on the "Cheque" worksheet sort of works, I'm getting the info I want but with a lot of stuff I don't want

Attached Files

Branch 2015 Accounts.xlsx (82.8 KB, 12 views)

You Brits are so cute with your royals and funny spelling! ;-) I am going to apologize right up front and spell everything in proper Amurikan. OK?

Some clarification please. So looking at January, what is Audit#, Receipt #, and Check (to the left of Check#)?

How is Check In indicated? Is it just when it is entered or is it when it's cleared the account.

The # indicates a number ie:
Audit Number (All expense receipts have a number)
Any Cash Paid Out goes in the Cash column and any Receipt Number goes in the Receipts number column
Any Cheques written goes in the Cheque column and the Cheque Number goes in Cheque # column (These are all cheques that have been issued)

Hope this is clear

Nope, you're totally right. OTH, this is a FREE forum whose members work for FREE on their spare time. Don't you think it's normal that one be urged to find existing solutions before re-creating what already exists ( at least eventually)?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I agree, Pecoflyer but as a newcomer to Excel, I did try to find the answer to my problem but could not find a solution. That is the reason I joined a forum.
I am a retired electronics engineer and and took over the roll of treasurer a year ago. This was when the accounts were done by hand, by a "Bookkeeper".
I have always thought that Excel was a powerful bit of software and I should use it to bring our Fellowship up-to-date.
So far the system I have created is working fine but I am always trying to improve it.
The data I require has already been inputted in the spread sheet and I thought there must be an easy way of extracting it, rather than putting the same figures in a seperate worksheet.
So any help would be grateful.

Marchie

Ignoring the non-excel recommendations since this is a learning exercise: Although you have obviously done a lot of work to get this workbook the way it is, I think that you could improve the workbook by taking a different approach.

Personally I would recommend you doing all your data entry into a single worksheet and then use Pivot Tables to break out each month's data. If you do a search for a Pivot table tutorials you will get an idea of why this would be a good approach. For instance, have a look at https://www.youtube.com/watch?v=Vx-Fuw46VbY

Tutorials will no doubt show you how to display data by the month and filter based on various parameters.

Thanks Guessed.
I will have another go with pivot tables and try with just one worksheet.