Excel 2007 : Populate Invoice fields based on Invoice number

Hi Marcol,

Thanks very much for your prompt reply and your suggestions, which as you mentioned did indeed get me started. The method that you suggested did seem to work well initially, I inputted about 17 client entries into the client database, starting with an invoice number of 5000, then 5001 etc. and the Client Invoice worked perfectly for invoice numbers 5000 to 5008, however as soon as I entered invoice number 5009 I got an invalid cell reference error.

I am doing this project to assist a friend who has recently bought a pest control company, whose invoicing methods are very outdated, he currently produces his invoices in MS Word!! The client database would run to maybe a couple of thousand clients.

I have attached the Client database with the 17 entries together with the Sample invoice to see if you or anyone else has any further suggestions.

Thanks in advance.

Glenn