John,
Thank you for your offer. I have sent you my email. I came back today to
copy all of the suggestions and to start trying to build this. I just saw
your post today for the first time, so sorry I didn't get back to you sooner.
If anyone else wants to offer suggestions, I would be more then happy to
give my email and YES I need all the help I can get. LOL.
Thanks again
Kevin

"John Calder" wrote:

Kevin

Email me your email address and I will send you a simple spreadsheet to do
what I think you are after. It uses a lookup table, data filter and a couple
of data validation lists.


John



"Kevin" wrote:

Wow.... Now you have gone over my head! LOL.... I have no idea how to use
VBA, but I like the suggestion. Sounds like I need to take a course in Excel
before I do this. Thanks for the suggestion tho, it sounds like a cool idea.
Just wish I knew what the heck I was doing in Excel. Or should I do this in
Access? That I am somewhat familar with having done a couple of SIMPLE
databases.

Kevin

"CLR" wrote:

Hi Kevin.....
It would be a bit of a project, but just to let you know what "could" be
done in Excel and using VBA......you could scroll down your list of songs
putting a "1,2,3 etc" in a column for each you choose for today......then
"push a button" and the program will place a copy of all those songs at the
bottom of another database which will eventually store all the songs you use,
and their "when used" data......then other buttons using Excel's built in
Autofilter, etc, could easily interrogate that database to give you reports
as detailed as "what song do we do FIRST on the second Sunday's of each month
the most", etc etc.........

hth
Vaya con Dios,
Chuck, CABGx3



"Kevin" wrote:

I may not be able to do this, but I figured someone on here could tell me. I
am a music minister and I am trying to create a list of all the songs we use
in the services. It will have the title of the song, the temp, key and last
time used and I would like to have a running total of how many times used
that year. Most of this I know how to create, but was not use how to get the
date last used to add up in totol of plays. Also is there a way to be able
to go back and see all the dates we used that song. I know I am asking alot
but I have tried to figure this out and have come up blank. Thanks for any
suggestions.