Ever watched a cup draw on television? I’m sure you have. Arguably, the most famous one is football’s FA Cup.
I’ve built the virtual equivalent in Excel. Of course, it cannot replicate the experience of picking balls out of a bag, pot or capsule, but it’s the next best thing!
I’m giving you free and unfettered access to the workbook so you can run your own draws and customise it as you require. That’s right, you can view and edit all the formulas and VBA code!
Let’s have a dekko at the workbook.
Before commencing with the draw, you must decide on the round and participants.
The process is:
- Choose the round from the dropdown.
- Input the club names into the table.
- Click the Proceed to Draw button.
A green circle and the Proceed to Draw button will only appear when the table is fully populated.
This is where the draw takes place.
The Draw Menu contains a group of Form Controls that determine what happens on the canvas.
Clears the canvas completely.
2. Instant Draw
Runs a complete draw immediately.