I want to a sequential number to fill in automatically each time the form is filled out. Malissa, A simple way would be to use something like this, you could assign it to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others...
I am trying to use mailmerge to print tickets. I tried using a column of sequential numbers on a spreadsheet and inserting that as a field into the mailmerge, but oddly, it used number 8 eight times on the first page, number 16 eight times on the second page, etc. So, I tried using a sequencing field as you describe. It worked great for the first page (numbers 1-8) but when I completed the mailmerge, it repeated numbers 1-8 on each successive sheet. What do I have to do to make this work in a mailmerge?
Running captions number figures, tables, and other items consecutively in a document. For example, the first figure caption starts with the words “Figure 1,” the second with “Figure 2,” and so on. To make sure that figures, tables, or similar items are numbered consecutively, define a list for the item, and then create a paragraph style that includes the list definition. You can also add descriptive words such as “Figure” or “Table” to the numbering scheme of the paragraph style.

Is there a way to auto number files with the file number (less .jpeg) and save without having to let my computer grind to a halt, as it does using Automate, contact sheet. The objective is to create a preview set for distribution to clients with the file number annotated at bottom centre. Also, is there any way of creating the text/font/colour/stroke of my choice?


If the list you want is as simple as "1", "2", "3", you'll appreciate how easy it is to apply this type of numbering in legal documents. Simple numbered lists are different in Word 2000 than they were in Word 97. In Word 2000, the default for even the most basic list is multi-level. For example, if you number an item and press Enter and then press the TAB key, Word automatically formats this number as the second level in an outline numbered list format. Single and multi-level numbering are explained later in this chapter.
Search sequential numbering and thousands of other words in English Cobuild dictionary from Reverso. You can complete the definition of sequential numbering given by the English Cobuild dictionary with other English dictionaries : Wikipedia, Lexilogos, Oxford, Cambridge, Chambers Harrap, Wordreference, Collins Lexibase dictionaries, Merriam Webster ...
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),"000-000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.

Thanks for the head start on this, it got me part the way through my problem but I found that when I had 3 figures in a row then a map, the next figure would jump back to #.1 again. Because I had figures, maps and tables that needed to be numbered I used the ‘levels’ to differentiate between them as you suggested, but found if you create a new number list for each entry ie. number list for maps, and number list for tables etc then they don’t conflict. thanks for the start off though. no where else pointed it out as clearly as this. Cheers

In this scenario we are assuming that there will be no more than 999 documents attached to a case. In Scenario 2 we assumed no more than 9999 inquires during a year. So you need to adjust the number of zeros when formatting Sequence for the anticipated number of records. Of course this can always be changed later. You also don’t need to format the sequence with leading zeros as the Format function does. As shown the expression returns something like: DCASD/CI123-025 for the 25th document in case CI123 for client DCASD. Without leading zeros it would be: DCASD/CI123-25. The advantage to the latter is that you don’t have to anticipate the number of records you might have in the sequence, but I’ve found many users prefer a more uniform number with the leading zeros.

Your raffle might be subject to gaming commission or tax laws. Check with your municipality, state or province, and federal governments to make sure your raffle is legal. These government departments aren’t just enforcers. They are often great resources on how to run a successful fund raising raffle. Raffles are fun! Getting in trouble with the law or tax man is not.

Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
I normally use "Data Merge" in InDesign and use Excel (or something like it) to generate the list of numbers for me. You would copy the numbers into a text file so that InDesign can read them as the merge data source. Note that you would have one ticket on the page and then let InDesign set the other tickets on the page (you can tell the Data Merge control panel about spacing).
Informally, a sequence has a limit if the elements of the sequence become closer and closer to some value {\displaystyle L}  (called the limit of the sequence), and they become and remain arbitrarily close to {\displaystyle L} , meaning that given a real number {\displaystyle d} greater than zero, all but a finite number of the elements of the sequence have a distance from {\displaystyle L}  less than {\displaystyle d} .

Determine what kind of numbering you want to use for your document or book. For long documents, you can assign chapter numbers. Each document can be assigned only one chapter number. If you want to use different numbering within a document, you can define ranges of pages as sections; these sections can be numbered differently. For example, the first ten pages of a document (the front matter) might use Roman numerals, and the rest of the document might use Arabic numerals.
Creating a sequential list of numbers, in Word, sounds like an intimidating task. Sure, you can create a numbered list quickly enough, but that feature works with additional text - you're numbering something. If you want a list of just numbers, you have to work a bit harder. Word's SEQ field might come to mind, but that solution is better suited to template-type numbering. In order words, this field works great if you're numbering documents, labels, and so on. It doesn't work so well if you just want to create a list of sequential numbers. You can use it that way, but it'll be more work than it's worth.
×