I have a list of 500 users and phone numbers in excel 2007. Every month I receive invoices for their phones in printed format. I have to do following:

1. Locate a row with the phone number whose invoice is in front of me. I may use Ctrl+F.
2. Enter the amount of current invoice in a cell.
3. Evaluate if the user has used more than his authorized limit.
4. Calculate the difference.
5. Generate a report.

The solution could be in one of following ways:

1. Create a search form, input phone number and retrieve data. Update data.
2. Use a barcode scanner to scan barcode from invoice. The value will be read in a cell in Excel. Invoke/trigger a macro to locate and edit the matching record.
3. Scan the front pages of invoices and read specific zones from invoice; export them in an excel list. Compare the lists and a macro should update the valuues - which may not be in the same order in both sheets.

I am looking for either a function-based or VBA solution. Please note I am a total idiot and would need complete instructions.

I will be thankful to all who will read it and would think about helping me.

NW