I have three questions regarding an invoice I created on Excel 2000.

1. How can I get the date to automatically update?

2. I'm trying to get it to put in invoice number in on each invoice. I'm
not sure how to do this I was wondering if it could updating the invoice
number every time I open the program?

3. I have a lookup function in the invoice when I can scan the bar code and
it bring up the item, however some of the bar codes are not in my system so
they bring up the closest thing, I was wondering if I could set it to bring
up an exact match or nothing at all?