Results 1 to 2 of 2

Thread: next number

  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: next number

    Is there a way to do this:
    I have a form called "List of Proposals Written" that is listed by the Proposal number.

    Is there a way to display on another excel spreadsheet, the most current Proposal number?

    I know Access you use something like Dmax(ProposalID)+1
    What should I do in Excel?

    Any help would be greatly appreciated!
    Michael
    Gotta to do some code

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by surfacesys
    Is there a way to display on another excel spreadsheet, the most current Proposal number?

    I know Access you use something like Dmax(ProposalID)+1
    What should I do in Excel?
    In Excel you can run many worksheet functions in VB by preceeding the function name with 'Application'

    Debug.Print Application.Max(Columns("A"))

    This will work if you are using a consecutive numeric value for your proposal numbers. If you have an alpha numeric id like prop123, prop124 ... then you will need to evaluate another way for example sort on the id field and check the last entry in the column.
    ~

    Bill

Posting Permissions

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