Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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..... :)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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..... :)


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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..... :)



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Numbering System Smurf613 Excel Worksheet Functions 1 July 13th 06 12:51 AM
Wacky IF Structire nevi Excel Worksheet Functions 5 June 24th 06 12:53 AM
Should be able to use bullets & numbering in Excel Brimac Excel Discussion (Misc queries) 1 June 7th 06 04:03 AM
Page Numbering starting on 3 Lynn Excel Discussion (Misc queries) 4 May 10th 06 09:26 PM
How repeat numbering for raffle tickets eg. 000001 - 000001 Ditha Excel Worksheet Functions 1 July 21st 05 03:53 AM


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"