[tomob]

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

 

[XL Guru]

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

Andy: Would you mind zipping and uploading here? (Did you notice we are now able to upload additional file extensions?)

Woohoo!

 

[XL Guru]

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

 

[Anne Troy]

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.

 

[XL Guru]

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