In this post, I want to take you through a spreadsheet that I created that can randomly select a sheet representing a tarot card.

🔮The file contains 22 worksheets each representing one of the major cards in the “Tarot de Marseilles” cards.

🔮A list of sheets is populated using a table of content macro

🔮Using =RANDBETWEEN() formula coupled with Index(), a random sheet name is selected.

🔮with a help of a user defined function, the name of the selected worksheet in the cell is converted to speech.

🔮all other non-selected worksheets are hidden using another macro.

All the above steps enables you to do tarot card reading using Excel.

✔️ Tarot cards (Both Texts and illustrations) are from: http://heb.cbdtarot.com/

✔️Text to speech is inspired by video tutorial by InAnOffice: https://www.youtube.com/watch?v=w-2If5plN4E

✔️ Table of content macro code is from Microsoft community: https://www.microsoft.com/en-us/microsoft-365/blog/2011/01/13/add-a-table-of-contents-to-your-workbook-its-easy-i-promise/

✔️ Unhide sheets based on a cell value: https://www.ozgrid.com/forum/index.php?thread/50417-hide-unhide-sheets-based-on-cell-value/

Download the working file: