Help with spreadsheet to do draw for a golf competition


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

 
 
Thread Tools Rate Thread Display Modes
  #1  
Old 11th August 2017, 15:33
Paul Sheppard's Avatar
Paul Sheppard Paul Sheppard is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with Excel
 
Join Date: Aug 2017
Location: Verwood, England
Age: 60
Posts: 2
Posts Per Day: 0.02
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 10 (1) Paul Sheppard is on a distinguished road
England
Default Help with spreadsheet to do draw for a golf competition
     Excel: General   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: General   

I am using excel 2010

I have made the attached spreadsheet to split players into 2 groups according to their handicap and then randomly allocate 2 players from each group to tees for a golf competition

If the draw is totally random everything works perfectly

Sometimes I want to be able to allocate certain people to certain tees, which is where I am having the problem

I've tried putting the name I want to allocate to a specific tee in the appropriate cell E1 on the Calc sheet, but this just results in a player getting missed out from the draw, D from Column A is not shown in Column E or F

What would I need to change to allocate a specific tee to a specific person? Or is there a better way than I have got currently

Thanks in advance for any help
Attached Files To view attachments in this forum your post count must be 2 or greater. You currently have 0 posts.



The Code Cage Advertisment
Advertisement
  #2  
Old 12th August 2017, 03:28
Leith Ross's Avatar
Leith Ross Leith Ross is offline
The Code Cage Staff
Solution Centre Professional
MS Office Version: 2000, 2003 & 2010
MS Office Skill Level: Expert in VBA
 
Join Date: Dec 2008
Location: San Bruno, CA USA
Age: 59
Posts: 470
Posts Per Day: 0.14
My Top Tip Count: 0
Thanks to others: 4
Thanked 53 Times in 51 Posts
Reputation: 997 (22) Leith Ross is a splendid one to beholdLeith Ross is a splendid one to beholdLeith Ross is a splendid one to beholdLeith Ross is a splendid one to beholdLeith Ross is a splendid one to beholdLeith Ross is a splendid one to beholdLeith Ross is a splendid one to beholdLeith Ross is a splendid one to behold
USA
Default Re: Help with spreadsheet to do draw for a golf competition

------ Register to get rid of these "In Post" ads! ------


Hello Paul,

Your workbook is using a lot of formulas and a few recorded macros. I don't see how or what triggers the code to run.
__________________
Sincerely,
Leith Ross

Microsoft Office Help



  #3  
Old 12th August 2017, 07:27
Paul Sheppard's Avatar
Paul Sheppard Paul Sheppard is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with Excel
 
Join Date: Aug 2017
Location: Verwood, England
Age: 60
Posts: 2
Posts Per Day: 0.02
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 10 (1) Paul Sheppard is on a distinguished road
England
Default Re: Help with spreadsheet to do draw for a golf competition

------ Register to get rid of these "In Post" ads! ------


Hi Leith

This is not the full version of my spreadsheet, I removed a worksheet to keep the file size small

The code is only used for:

Sorting the names into handicap order on the Names sheet
Copying and pasting values from the Draw sheet to an identical sheet called Start Sheet
Sorting the data on the missing Start Sheet, my formulas fill down the sheet from holes 1 through 18 and then start again at hole 1A through 18A, when the data has been transferred it is sorted so the holes run 1, 1A, 2, 2a.......
Hiding any empty rows on the Start Sheet before it is printed
Unhiding empty rows on the Start Sheet for future use

Everything is driven by formulas, so I was asking how the formulas would need to be changed to fit my request. My VBA is limited hence the formula approach

If a formula based answer is not possible a VBA solution would be ok

Hope this helps, if you need more info let me know

Paul



The Code Cage Advertisment
Advertisement
 
The Code Cage at Facebookhe Code Cage at Twitter


Tags
competition, draw, golf, spreadsheet

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 04:40.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.16867 seconds
  • Memory Usage 6,338KB
  • Queries Executed 16 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (2)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (3)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (3)navbar_noticebit
  • (52)option
  • (3)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (1)postbit_attachment
  • (3)postbit_ctoptip
  • (3)postbit_onlinestatus
  • (10)postbit_reputation
  • (3)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (4)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • reputation_power
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • error_fetch
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete