1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

excel input form for a golf league

Discussion in 'Business Applications' started by tomob, Apr 7, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. tomob

    tomob Thread Starter

    Joined:
    Dec 18, 2003
    Messages:
    213
    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???
     
  2. XL Guru

    XL Guru

    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
     
  3. Anne Troy

    Anne Troy

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

    Woohoo!
     
  4. XL Guru

    XL Guru

    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
     
  5. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    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.
     
  6. XL Guru

    XL Guru

    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
     

    Attached Files:

  7. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/218187

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice