Hi,

Show us some sample data please, at least the invoice number data.

And what if 201 has been assigned and now 205 is assigned, should that
generate an error?

I also would make the suggestion that your numbers run from 200 to 299 not
from 201 to 300.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"tofimoon3 via OfficeKB.com" wrote:

Dear sir,with my regards,want to ask : i have a workbook with some sheets,one
of them contains( date,no.of invoice,amount) ,the invoices begin with( 101-
200 for A agent,201-300 for B agent, and so on for about 15 agents) ,is it
possible in excel 2003 to have a (warning) if i register no. 115 before 114
for agent A for example because i want to register the invoices nos.for each
agent sequensly.
Thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200903/1