About Us

YJOHN5217

"Otto Moehrbach" wrote:

VBA is a programming language that is built-in to Excel that allows the user
to utilize the programming features of Excel. Look in Excel help for Data
Validation. I'll build a small file for you and you can take it from there.
Send me an email and I'll send you the file. Otto
"YJOHN5217" wrote in message
...
Yes I need help. I'm searching MS website for VBA and data validation
instructions.

"Otto Moehrbach" wrote:

Yvette
Post back if you need/want help with that. Otto
"YJOHN5217" wrote in message
...
Thank you for the reply! Yvette
"Otto Moehrbach" wrote:

There are numerous ways you can do what you want. I would have one
sheet
with all the member's names in, say, Column A. Each member's row
would
include date and dollars paid. In other words, say John is in Row 10
Column
A. B10 would have a date and C10 would have the money he paid on that
date.
If he paid again, the date would be in D10 and the money in E10, and
so
forth. No manual entries would be made in that sheet except for the
names
in Column A.
I would have a data entry sheet that would have one Data Validation
cell
with a list of all the members, and 2 other cells for the date and
amount
paid. That's all that would be on that sheet. I would employ VBA
that
would automatically transfer the date and amount paid to the sheet
described
above, in the row of the selected member.
I would have a 3rd sheet that would be the printout sheet at the end
of
the
year. Again, I would use VBA to print a single member's data or all
members' data at one time. You might also want to simply view one
member's
data. This could be done by clicking on a button in the sheet that
has
the
Data Validation cell. As I said, there are many ways to do this. HTH
Otto
"YJOHN5217" wrote in message
...
I'm working on a spreadsheet for my club. I want to keep track of
money
collected and to provide a printout for each member's total donation
at
the
end of the year. I have a list of members' names (300 people). I
tried
using
Access but had problem with the pull-down and selecting an
individual
member.
What's the best way to create the spreadsheet? One member may pay
several
times a year. Should I have one worksheet with member's name that
points
to
another worksheet that allows me to enter date/money turned in?
Again,
at
the end of the year, I want to be able to print out the total
member's
donation. THANK YOU!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assistance with setting up of Spreadsheet, to enter, manage and re	Princesscharlie71	Setting up and Configuration of Excel	1	May 14th 09 06:53 AM
How can I track the date of changes to a spreadsheet ?	Sharon06	Excel Discussion (Misc queries)	2	November 4th 08 04:07 PM
How to report changes in a spreadsheet (not track changes)	Epoch	Excel Discussion (Misc queries)	0	June 27th 08 11:36 AM
Excel Spreadsheet Assistance (Match, Compare)	Nancy	Excel Worksheet Functions	1	January 17th 07 02:05 AM
Creating a spreadsheet in excel to track inventory	Dana Schuchman	Excel Discussion (Misc queries)	4	September 11th 06 04:46 PM

Menu

About Us