Are you assigning the invoice numbers offline or when you are registering
them in Excel?

If you do the latter, you could simply fill the Invoice# column with all
possible numbers for the agent in the correct order and then fill out the
details (date etc.) once you want to register the next invoice.

If you assign the invoice numbers offline, you could simply add them to the
agent's worksheet and then resort all rows by the invoice number in ascending
order.
--
Regards,

Ulrike

PS: If this post helps, click YES


"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