I am working on a spreadsheet for use in a dispatch office. It would be very helpful if I could make excel auto complete a range of cells, for instance when a customer calls in, I would begin typing their name, and if we have done work for them before, the rest of their information could automatically go into the appropriate cells. I am not sure how to go about this, I am using excel 2007, and would also like to automatically insert links to previously completed invoices. If anyone can help me it would be greatly appreciated.
Bookmarks