+ Reply to Thread
Results 1 to 1 of 1

Tables & Named Ranges

  1. #1
    Registered User
    Join Date
    04-15-2009
    Location
    morristown, ny
    MS-Off Ver
    Excel 2007
    Posts
    39

    Talking Tables & Named Ranges

    How can I have a table increase the number in the Sequence Field record each time a record is added.

    The GMP part is from Custom Formatting.

    I have tried Offset, Index, Row, and Rows.

    I have a number of these tables set up for different job discriptions. I have the first one that actually increases the Sequence number the way I want, but I can not get it to work on others. I have copied the formula, the format, and made sure the table ranges are setup the same. The one that works is base on the cell above =+A5+1, then =+A6+1. When I get to the end of the table and tab to add another record that above formula is automatically added to the next record. Can't get it to work on the rest!




    Sequence # GMP's - Good Manufacturing Practices
    GMP 1 Caps on lines. No product contact surface can be left open.
    GMP 2 Gasket changes are basic to every process and packaging
    GMP 3 Clean floors, walls, ceiling, drains, pipes, overhead lines, job.
    GMP 4 Housekeeping: do not not by something; pick it up.
    GMP 5 Doors closed
    GMP 6 Hair and beard nets are required in all processing areas.
    GMP 7 No stock on floor to include platforms
    GMP 8 Proper place for junk cardboard
    GMP 9 How to properly clean up spills in the machine
    GMP 10 Uniforms - clean, proper

    The solution I found:
    ROW(Table_Day_4_UF_Production[#This Row])-($A$28+1)
    Last edited by ed ayers315; 04-10-2010 at 08:42 PM. Reason: Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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