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

[Milagr]

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

 

[vletm]

Milagr
As You have seen something then You would upload a sample file here.

 

[Milagr]

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

 

[p45cal]

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.

 

[Milagr]

Thank you. Request to please help as this is the error am getting.

 

[Milagr]

please find attached the words I want to use. Thank you

 

[p45cal]

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

 

[Milagr]

Thank you. Please find below:

 

[Milagr]

My apologies, it wasn't the full line. Please find below:

 

[p45cal]

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

 

[Milagr]

Thank you so much

 

[Milagr]

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

 

[rupesh.jakhotiya]

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.

 

[vletm]

rupesh.jakhotiya
You should open a new thread for You.
This thread belong to Milagr.