excel input form for a golf league

>> 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

>> 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. 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. ; 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