The attached Fishing Comp workbook consists of three sheets, namely Results, Standards and Data.
The Results worksheet contains a leaderboard and 4 active x command buttons. Whilst the leaderboard is relatively dynamic, it needs to be more so to be better functional. At this stage its manually designed.
The Standards worksheet contains a series of tables which govern how the fishing comps are to be run. The two important ones are the SOFish table which is used to determine which fish of the 10 targeted fish are important to the active fishing comp, and how many points are assigned to which fish.
The Fees table is used to determine the entry fee for each team. Fees are applied on a per comp basis and will be changed from time to time
The Data worksheet is to be used to store the relevant comp data and is only a stop gap measure as the club intends to use Access to store the details as their experience grows.
As this is a learning experience a series of questions will be developed as the project develops, so any assistance offered will be greatly received.
A userform has been designed to collect data for those teams and is called by the cmdButton “Entry”. Using this as our first lesson, how do we get this to both the Leaderboard and to the Data sheet? A new leaderboard will gain in both rows as more entries are entered, and the columns dedicated to each fish targeted in the active comp will change as will the column headings per fish.
Reply With Quote