Next sequential number on a different form

D

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:confused:



Any help would be greatly appreciated!

Michae
 
M

Max

daniels012 > said:
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?
Click to expand...

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)
 
Top