Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
without macros, how can one create labels in excel
I do not yet know macros. I would like to create a label template allowing
information to be written and that would automatically add a label #. Any suggestions would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
without macros, how can one create labels in excel
I don't know that there's a way to do this without macro coding of some type.
Excel does not have the ability to change a value in a cell to keep an updated count. That is to say, you can't say "take a value in a cell, add one to it and replace the value in the original cell with that new value". Not with worksheet functions. A source of a couple of solutions for the matter can be found on J.E. McGimpsey's site and they seem to be the de facto standard for doing this kind of thing: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html "DooDah" wrote: I do not yet know macros. I would like to create a label template allowing information to be written and that would automatically add a label #. Any suggestions would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
without macros, how can one create labels in excel
Are you attempting to create something like raffle tickets with a sequential
number for each ticket? I would not bother making the tickets in Excel. Have the information in Excel with a column of numbers 1 to whatever you need for amount of tickets. Then use Word mailmerge for the tickets. One of the fields will be the column of numbers. New number for each ticket assuming each record is on one row. Assuming you are using Word for the mailmerge and Excel for the source see these sites for help. 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, 14 Feb 2008 08:09:02 -0800, DooDah wrote: I do not yet know macros. I would like to create a label template allowing information to be written and that would automatically add a label #. Any suggestions would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use Excel to create labels? | Excel Discussion (Misc queries) | |||
Create Labels from within Excel | Excel Discussion (Misc queries) | |||
How do you create address labels from an excel document? | Excel Discussion (Misc queries) | |||
How do I create mailing labels from microsoft excel | New Users to Excel | |||
How do create address labels in excel. | Excel Discussion (Misc queries) |