Cup Draw Simulator — Excel Edition

Andrew Moss
4 min readMay 13, 2022

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:

  1. Choose the round from the dropdown.
  2. Input the club names into the table.
  3. 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.