+ Reply to Thread
Results 1 to 2 of 2

Excel 2008 : [SOLVED] Best Way to Increment a Number for a Shipper

  1. #1
    Registered User
    Join Date
    07-23-2011
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2008 for Mac (Japanese), Excel 2011 for Mac (English)
    Posts
    13

    [SOLVED] Best Way to Increment a Number for a Shipper

    Here's the scenario: We have a fork-lift operator using a truck loading log similar to the one I inquired about here for loading commodities onto a semi truck. In this same workbook, there will also be a worksheet for the shipper, which pulls the subtotals and grand totals of the loading log. Each shipper needs to have a shipper number on it, much like an invoice number would.

    The process is as follows: The fork lift operator opens a new truck loading log, fills it out, and then emails it to an employee at the front desk. It is this employee that must print out the shipper and hand it to the truck driver to sign. However, this presents somewhat of a problem. Even if I add code to have a particular cell increment by one every time the file is opened, it will most likely increment by two every time a shipper is printed (again, the fork lift operator opens the file once, closes it, emails it, then the front desk employee opens it again before printing it out).

    I'd like to avoid the front desk employee having to enter a shipper number manually based on remembering what the previous number was, so I guess my question is this: What is the best way to increment a number for a shipper (I imagine some people have had similar problems with invoice numbers before)?

    Pardon the novel, any advice is greatly appreciated.
    Last edited by friedland_industries; 08-16-2011 at 02:32 PM. Reason: solved

  2. #2
    Registered User
    Join Date
    07-23-2011
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2008 for Mac (Japanese), Excel 2011 for Mac (English)
    Posts
    13

    Re: Best Way to Increment a Number for a Shipper

    Nevermind, I figured something out!

    Basically, I just created a macro to clear the contents of the current log and then increment the shipper number by one. So every time the forklift operator emails a log, he'll then click the New Log button (clear contents, increment shipper number by one).

    All good :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1