Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2015, 04:09 AM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
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
  #2  
Old 01-08-2015, 05:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,420
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

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
Reply With Quote
  #3  
Old 01-08-2015, 07:13 AM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Default

Hi Pecoflyer.
Yes, look on the net but could not find one that fitted our needs, so worked from cratch.
Reply With Quote
  #4  
Old 01-08-2015, 08:32 AM
gebobs gebobs is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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/
Reply With Quote
  #5  
Old 01-08-2015, 09:31 AM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 01-08-2015, 09:46 AM
gebobs gebobs is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #7  
Old 01-08-2015, 10:20 AM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Default

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
File Type: xlsx Branch 2015 Accounts.xlsx (82.8 KB, 6 views)
Reply With Quote
  #8  
Old 01-08-2015, 10:53 AM
gebobs gebobs is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Marchie View Post
On the expenditure sheet I have columns for: Date, Description, Cash, Cheque, Amount and Cheque Number.
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#)?

Quote:
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.
How is Check In indicated? Is it just when it is entered or is it when it's cleared the account.
Reply With Quote
  #9  
Old 01-08-2015, 11:59 AM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Default

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
Reply With Quote
  #10  
Old 01-08-2015, 01:01 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,420
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Quote:
Originally Posted by Marchie View Post
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
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)?
Reply With Quote
  #11  
Old 01-08-2015, 05:40 PM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Default

Quote:
Don't you think it's normal that one be urged to find existing solutions before re-creating what already exists ( at least eventually)?
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.
Reply With Quote
  #12  
Old 01-09-2015, 12:01 AM
Guessed's Avatar
Guessed Guessed is offline Newbie needs help with Excel Windows 7 32bit Newbie needs help with Excel Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,654
Guessed is a glorious beacon of lightGuessed is a glorious beacon of lightGuessed is a glorious beacon of lightGuessed is a glorious beacon of lightGuessed is a glorious beacon of light
Default

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.
Reply With Quote
  #13  
Old 01-09-2015, 03:10 PM
Marchie Marchie is offline Newbie needs help with Excel Windows 7 64bit Newbie needs help with Excel Office 2010 64bit
Novice
Newbie needs help with Excel
 
Join Date: Jan 2015
Location: Leeds, West Yorkshire, UK
Posts: 7
Marchie is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet. rogcar75 Excel 0 08-12-2014 07:21 AM
Excel newbie help - formula 1967Mustang Excel 2 05-15-2014 07:22 AM
Newbie needs help with Excel newbie help please cjpga Outlook 2 06-23-2011 01:24 PM
Perhaps a newbie question I know but as1947 Excel 0 02-05-2009 08:01 AM
Newbie needs help with Excel Hello all! Newbie here with a queston spamh8tr Outlook 1 11-30-2006 08:04 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft