+ Reply to Thread
Results 1 to 3 of 3

To display last entry number + 1

  1. #1
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    To display last entry number + 1

    Hello

    I am Using Excel 2007 for printing Purchase Order.

    When I enter the data and updating, I need the P.O Number cell ("V4") in PO sheet
    to display new PO number.

    Example when I finish entering PO # 690 & Updated, the cell V4 should display
    691 (The new PO Number).

    Please help me.

    Regards
    Charles
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,061

    Re: To display last entry number + 1

    Do you need:

    =MAX(POData!B:B) or =MAX(POData!B:B)+1
    Never use Merged Cells in Excel

  3. #3
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: To display last entry number + 1

    Ok, this formula i can place in V4.

    but when move the entry up & down the formula disappears and the
    only value will be there.

    regards
    Charles

+ 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