excel input form for a golf league

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

tomob

Thread Starter
Joined
Dec 18, 2003
Messages
214
we run a golf club and have rregular tourniments,, everyone has a 3 digit member number, now any given day as we play you can earn credits or points... We would like to have the entry ask for Number date and points earned.. The print regular reports at the end of each tounry

anyone have anthing or Ideas???
 
Joined
Aug 30, 2003
Messages
2,702
>> anyone have ... Ideas???

A little data validation for the member #s ; some worksheet code to smooth the input ; a pivot table to summarise the points with a page field for the tourny date(s).

>> anyone have anthing

Not off the peg ; but I saved what I managed to knock up in 10 minutes (really needed some r'n'r after struggling with Michael's Word code).

If you'd like a copy, mail me at andy.j.brown
@ntlworld.com ; but right now I need some shut-eye.

Rgds,
Andy
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Andy: Would you mind zipping and uploading here? (Did you notice we are now able to upload additional file extensions?)

Woohoo!
 
Joined
Aug 30, 2003
Messages
2,702
>> Would you mind zipping and uploading here?

Hey Anne, that's a good question. The wb contains ;

1. Data Validation
2. VLOOKUP thru VBA
3. Worksheet/event code
4. Dynamic named ranges

You've already covered 1 and, to a degree, 2 on the web. Re: 3, I don't do proper code, so I'm not sure it would be a good idea to put it in the public domain -- might do more harm than good. :eek: Plus it would cause work for ppl who do do proper code, having to point out what's wrong w/it (mentioning no names, but I'm thinking palm trees, leis, etc. :D ; no offence intended).

That said, 4 can be v useful IMO. So if it ended up being tweaked (from feedback) into something generic that added some value, then it might be worthwhile.

What say you?

Rgds,
Andy
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
ROFL!!!!

>>palm trees, leis...

You're too much!!
I don't want it uploaded for ME. Truth is, I probably wouldn't even look at it. But other people who search Mikey's database might find it useful. But I hear you--I've made stuff I wouldn't put in public domain, LOL.
 
Joined
Aug 30, 2003
Messages
2,702
>> other people who search Mikey's database might find it useful.

Of course you're right. Plus in my enthusiasm, I forgot to pay much attention to the actual question. :eek: I'll change my reply for something that does what it says on the tin.

tomob, Excels' built-in DataForm may fit your needs. Normally you'd run it from the Data menu, the attached file has code that runs it automatically when the relevant sheet is selected.

Rgds,
Andy
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top