I currently have a LISP routine that will replace the value of a specific attribute name with sequential numbers in the order that the blocks are selected. Like TCOUNT for attributes – and it only looks for a specific attribute Tag Name called “ID”.
We created a spreadsheet with numbers running in one column in 4-out number groups: 1, 251, 501, 751, etc. and use the multiple records set-up. Our recent challenge was to take that spread sheet and do the 4-out number groupings in threes for reverse collate 3-part NCR on a copier. Takes a bit of time to set up but worth it in the long run.
Word’s Numbering Explained by John McGhie, MVP – comprehensive and not pretty (Downloadable pdf file in letter size) – Reading this is vital to anyone attempting to use automatic numbering or bullets in a law office setting or other places where the documents are likely to be reused or heavily edited. See also How to Create a Template with a downloadable template with style-based numbering. I strongly recommend that you read both of these before doing anything with the contents of this chapter.
Now, you’ll define the actual merge values. In this case, it’s the Ticket Numbers field in the selected Excel workbook. Drag the Ticket Numbers field from the merge pane to the document (Figure G). After dropping the field control, I pressed [Enter] to replace Microsoft with the <
For whatever reason, AllExperts did not let me post a direct reply to your response re: “Ok, what is the ControlSource of the Fixture Number control? It should be: =cboZone & “-” & Format(Me.FNumber,”000″)” and adding “Me.Refresh” to my code (within the last 10 minutes). It just had the “rate this reply”. I added the Me.Refresh and corrected my location of the =cboZone code and it works correctly now.
Hello! I would like to chart varying salaries against specific Low, middle and high numbers. Any suggestions on how to show this? Example: Salary 1 10000 Salary 2 12000 Salary 3 16000 Low 9000 Mid 15000 High 19000 THANK YOU! Do you want the Low-Mid-High values to be like a benchmark to measure salaries against? You could put horizontal lines across your chart, and use markers for the salary data. Here’ a few ways to get your lines: http://peltiertech.com/Excel/Charts/AddLine.html – Jon ——- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials…
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
If you are working in with chapters in an InDesign book file, and the second and subsequent chapters don’t reset the Subhead 1 and Subhead 2 numbers, return to those chapters and choose Type > Bullets & Numbering > Define Lists > [Your list name] > Edit and uncheck Continue Numbers from Previous Document in Book.
I have an opportunity to make a good impression at a new job, but ive never had the initiative to learn how to write a lisp routine. at my work we make walk-in coolers and freezers. these coolers are modular with a standard wall piece measuring a certain length. these wall sections have to be numbered sequentially. is there any way to automate this? sometimes we get change order from the client and it means going back and manually changing multiple texts (sometimes in the hundreds), but i thought if there was a way these wall sections could be scheduled somehow that when a new wall panel is inserted in the beginning of the sequence it would update everything after it automatically.
Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task. Rather than performing it manually, however, you can automate it, although the process varies slightly depending on whether you want the numbers to remain the same or change to reflect their new position if you move, add or delete rows.
Go to the Insert tab > Text group, then click the Quick Parts icon. Your two new Quick Parts entries are listed in the drop-down — hover over each to see the Description you added displayed as a tooltip.
Short of doing it manually (!), Linc, I’d suggest you experiment with some of the number formatting switches for a field code, as described here: http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx#BM8.
For example, to create a “Figure A” effect, enter the word “Figure” and a space before the numbering metacharacters (such as Figure ^#.^t). This adds the word “Figure” followed by a sequential number (^#), a period, and a tab (^t).
This example assumes that a production-line monitoring process receives notification of events that occur throughout the workshop. Each event receives a unique and monotonically increasing EventID number. All events use the same EventID sequence number so that reports that combine all events can sequential numbering in coreldraw identify each event. However the event data is stored in three different tables, depending on the type of event. The code example creates a schema named Audit, a sequence named EventCounter, and three tables which each use the EventCounter sequence as a default value. Then the example adds rows to the three tables and queries the results.
If you use numbers, you could generate a CSV-file using Excel. Start by putting the first number in the desired sequence in a cell and then drag this cell in the border downwards. Excel should now make a list of incremented values, you can export to csv.
I am trying to add page numbers to an existing document. I have tried to add them in Prepress, but all I see is the “Print File Information” and even that is not in a location I want. I have the “Position Within Page” checked.
Tip Microsoft strongly recommends that you link your numbering to styles. The importance of this will be very apparent during the Outline Numbered section. Also, there is more information on the importance of styles when working with numbering in the Styles chapter.
Decide whether you want the first or last occurrence of the style that’s applied on the page. First On Page is the first paragraph (or character) that begins on a page. If there is no occurrence of the style on the page, the previous occurrence of the applied style is used. If there is no previous occurrence in the document, the variable is empty.
Click that, and a placeholder will appear where your cursor was, which will later insert the ticket number at that point. Do that twice for each ticket (once for the counterfoil, once for the main ticket). You should end up with something like this: