Next sequential number on a different form

[daniels012]

Is there a way to do this:

I have a form called "List of Proposals Written" that is listed by th
Proposal number.



Is there a way to display on another excel spreadsheet, the mos
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!

Michae

 

[Max]

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?

Assuming the list of proposal numbers is in Sheet1, col A

In Sheet2:

Put in say, A1:
=MAX(Sheet1!A:A)
or
=MAX(Sheet1!A:A)+1
(to get the next number)

 

[Jason Morin]

If your proposal #'s are in column A, try:

=MAX(A:A)

HTH
Jason
Atlanta, GA