ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numbering as for a raffle ticket (https://www.excelbanter.com/excel-discussion-misc-queries/116295-numbering-raffle-ticket.html)

Mom needs help!

Numbering as for a raffle ticket
 
I need to know if it is possible to number a specific cell consecutively for
a kids fundraiser. If it is possible, I need to know how to set it up....
PLEASE HELP! Mom on a time crunch..... :)

Gord Dibben

Numbering as for a raffle ticket
 
That would all depend upon how the ticket data is laid out and you give very
little detail.

Printing these directly from Excel can be a pain due to formatting.

I do up a lot of numbered tickets for a couple of associations I belong to.

I set up my ticket data in Excel in columns with a column for numbers then I
use Word Mailmerge to print the tickets.

If you want duplicate numbers on each half of the ticket, set up the numbers in
two columns rather than one.

Printing labels or tickets from Excel is trial and error but can be done.

Word does a fine job because it is designed for that type of operation.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 12:06:02 -0700, Mom needs help! <Mom needs
wrote:

I need to know if it is possible to number a specific cell consecutively for
a kids fundraiser. If it is possible, I need to know how to set it up....
PLEASE HELP! Mom on a time crunch..... :)



Mom needs help!

Numbering as for a raffle ticket
 
THANKS for your help!!!!!! I was able to accomplish my mission in word
thanks to your advice on mail merge. I had 2 pictures and had it set up as a
2 part ticket. I just copied the 2nd one over to the otherside and it worked
great!

Thanks,
Marie

"Gord Dibben" wrote:

That would all depend upon how the ticket data is laid out and you give very
little detail.

Printing these directly from Excel can be a pain due to formatting.

I do up a lot of numbered tickets for a couple of associations I belong to.

I set up my ticket data in Excel in columns with a column for numbers then I
use Word Mailmerge to print the tickets.

If you want duplicate numbers on each half of the ticket, set up the numbers in
two columns rather than one.

Printing labels or tickets from Excel is trial and error but can be done.

Word does a fine job because it is designed for that type of operation.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 12:06:02 -0700, Mom needs help! <Mom needs
wrote:

I need to know if it is possible to number a specific cell consecutively for
a kids fundraiser. If it is possible, I need to know how to set it up....
PLEASE HELP! Mom on a time crunch..... :)




Gord Dibben

Numbering as for a raffle ticket
 
Happy to hear.

Thanks for the feedback.

Gord

On Thu, 26 Oct 2006 13:59:02 -0700, Mom needs help!
wrote:

THANKS for your help!!!!!! I was able to accomplish my mission in word
thanks to your advice on mail merge. I had 2 pictures and had it set up as a
2 part ticket. I just copied the 2nd one over to the otherside and it worked
great!

Thanks,
Marie

"Gord Dibben" wrote:

That would all depend upon how the ticket data is laid out and you give very
little detail.

Printing these directly from Excel can be a pain due to formatting.

I do up a lot of numbered tickets for a couple of associations I belong to.

I set up my ticket data in Excel in columns with a column for numbers then I
use Word Mailmerge to print the tickets.

If you want duplicate numbers on each half of the ticket, set up the numbers in
two columns rather than one.

Printing labels or tickets from Excel is trial and error but can be done.

Word does a fine job because it is designed for that type of operation.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 12:06:02 -0700, Mom needs help! <Mom needs
wrote:

I need to know if it is possible to number a specific cell consecutively for
a kids fundraiser. If it is possible, I need to know how to set it up....
PLEASE HELP! Mom on a time crunch..... :)




Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com