+ Reply to Thread
Results 1 to 4 of 4

Bowls competiion draw sheet program

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    Brighton, England
    MS-Off Ver
    Excel2010
    Posts
    22

    Bowls competiion draw sheet program

    Hi All,
    Not sure anyone can help me with this problem but here goes anyway.
    The attached file contains the program that runs our County Draws for all competitions. I am only able too draw and print but unable to save what is produced. Being able to save what is produced would help a lot as it has to go off to the printers in printed form and then be typed in by them for the Diary/Booklet that it will produce. Of course having to copy all that information has to be proof read for errors that might creep in when re-typing the information.

    So being able to do the draw and then saving this info would be valuable in cutting down time spent proof reading and also being able to send this information directly to the printers for downloading straight into their finished product.

    Any ideas?

    Thanks for looking
    Mike
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Bowls competiion draw sheet program

    I had no trouble entering data and using File, Save As to save the file. I then reopened the file and entered new data and could save that also just like any other Excel file.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    04-26-2013
    Location
    Brighton, England
    MS-Off Ver
    Excel2010
    Posts
    22

    Re: Bowls competiion draw sheet program

    I should explain that you are only seeing the front end data on the screen that you enter into the divisions 1-4.

    What is generated when you print is very different it is a list of numbers and the next round numbers in brackets.
    To explain, if you were competitor number 4 and were playing competitor number 18 next to those two numbers is a bracketed number which is your next round opponent should you win

    i.e. 4-18 (27) and so on throughout the draw.
    It is this that gets printed out, but can't be saved.

    The front screen is merely the user input window.

    Thanks for looking
    Mike

  4. #4
    Registered User
    Join Date
    04-26-2013
    Location
    Brighton, England
    MS-Off Ver
    Excel2010
    Posts
    22

    Re: Bowls competiion draw sheet program

    I should explain that you are only seeing the front end data on the screen that you enter into the divisions 1-4.

    What is generated when you print is very different it is a list of numbers and the next round numbers in brackets.
    To explain, if you were competitor number 4 and were playing competitor number 18 next to those two numbers is a bracketed number which is your next round opponent should you win

    i.e. 4-18 (27) and so on throughout the draw.
    It is this that gets printed out, but can't be saved.

    The front screen is merely the user input window.

    Thanks for looking
    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. draw median to sheet 2 from sheet 1
    By Mak2145 in forum Excel General
    Replies: 2
    Last Post: 06-29-2011, 08:02 PM
  2. Using number in one sheet to draw content from another sheet
    By mike_m1 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-05-2010, 04:20 PM
  3. [SOLVED] Can you program Excel to draw an asymptote?
    By csusbgirl07 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-22-2006, 10:25 AM
  4. Replies: 1
    Last Post: 10-25-2005, 11:05 AM
  5. [SOLVED] please draw excel sheet for the following
    By saigopal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1