• 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

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
 

p45cal

Well-Known Member
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

p45cal

Well-Known Member
The file you attached worked straight out of the box here.
What line is higlighted in yellow when you click Debug?
 

p45cal

Well-Known Member
You must be using an older version of Excel?
Try removing the 2 from both instances of Add2 in the code.
 

Milagr

New Member
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
 
Top