View Single Post
 
Old 11-21-2011, 05:51 PM
leahca leahca is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Oct 2011
Posts: 12
leahca is on a distinguished road
Default Searchable list in excel?

Hi All,

I am wondering if it is possible in any way to create a searchable list in excel?

We have a 'job costing sheet' that staff fill in and send to me for invoicing which has a data validation cell at the top connected to a 'list' of customers. The staff find it painful going through a very large list to find the customer they need and would like to instead be able to click in the cell, start typing 'Ap..' for example and customer 'Apple' automatically appears. Or even if they type 'G' and it automatically brings them to the list of customers starting with G.

Any ideas on how I can get around this? The result of this list is also connected to a Vlookup in the cell next to it to bring across the correct accounting code.

Thanks!
Reply With Quote