Creating an Order Form

Hi,

I am a self taught Excel user and Sales Manager for SME business in London and selling across the UK and Eire.

I've created a simple order form using Select From List, Vlookup and simple formulas. I require the order form to be offline for the Sales Team and everything works fine, the problem I encounter is that we sell 5000 SKU's which is a big list to scroll thru when looking for a specific product and tiny font in the Select From List, my question is 3-fold:-


1: Is Excel the right product I should be using for this? I want to build this myself to keep costs down to a minimum, I've looked around and there are Online Sales Order forms but I think these provide much more than I'm looking for and monthly rates apply.

2: If Excel is the way forward then ideally I would want to free-type in the product code cell of the order form (which I'm currently using as Select From List) and the cell look for a value which smartly matches any part of the product code to product code column in my data tab (I use 3 tabs - tab 1 = Order, tab 2 = EDI friendly form which I transmit to office to 'suck' into system so no re-entering, tab 3 = all data which feeds tab 1)?

3: Is there any way to increase the font size in the Select From List window?

I hope the above makes sense and someone can point me in the right direction.

Many thanks

Doulie