• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use words to make a housie ( tambola ) ticket

Status
Not open for further replies.

Milagr

New Member
I have seen the excel sheet to make housie tickets that has numbers, May I request to please help me in putting words instead of numbers to make the tickets.
Thank you so much for any help
 
Milagr
As You have seen something then You would upload a sample file here.
thank you. I have downloaded from the net, and got it from this link chandoo.org. Never the less am attaching the same. Thank you
 

Attachments

  • bingo-housie-ticket-generator-excel-sheet.xlsx
    81.7 KB · Views: 43
Click the refresh button ot the top left of the sheet in the attached.
Edit the words in the green cells in AR5:AR93 to your words.
 

Attachments

  • Chandoo44920.xlsm
    31.1 KB · Views: 38
please find attached the words I want to use. Thank you
 

Attachments

  • Chandoo44920.xlsm
    30.8 KB · Views: 24
The file you attached worked straight out of the box here.
What line is higlighted in yellow when you click Debug?
 
You must be using an older version of Excel?
Try removing the 2 from both instances of Add2 in the code.
 
Yes it worked. Thank you. My next challenge is to forward each ticket to participants on whats app. Any help/ suggestions, would be obliged. Thanks again
 
Is the word excel working fine to generate work Tambola ticket? In Tambola each row should have 5 values . when I hit refresh, I get 1 row with 5 values, another row with 4 values and 3rd row with 6 values. Attached is file I got after refresh.
 

Attachments

  • Chandoo44920.xlsm
    30.5 KB · Views: 9
Status
Not open for further replies.
Back
Top