Hi,

I read countless thread about what i want to do but cannot manage to get it working so if someone would be so kind to help me out i would be grateful.

A colleague asked me to write him a spreadsheet that is easier/smarter to use and could aggregate all of the required field of several other documents. (Those are Internet Provider Order document). Some of those information are available in a database and some needs to be filled manually.

So i imported in a spreadsheet our locations database (~7k entities) with several column header : A to V in fact, so 22 columns (Site code, address, Provider, Phone number etc).

I would like have a textbox / ComboBox on a spreadsheet (The First one, in fact) to search as you type this array (Not needed to search ALL of the column, only site code, ZIP Code, address and phone numer should be enough) and would autopopulate cells below the box with the cells information of the selected row when selected, and not just copy the entire row so i can make some display change, like selected field from column A would go to cell X on the first sheet, column B to cell Y etc

This way i could just take those cells + manually filled one and export them to the real command order and the user just have to click "generate" and the real command order pop-up already filled and he just sign, save & send. (This part i'm fine with, open another Workboot and copy value from cell to cell is easy enough for me...). We have 3 different providers and this would be used by newcomer because it would be easier to use (Autofill with the information we have, and just the required field are displayed instead of several sheets and not needed cells on the real command order.

Hoping that my explanations are understandable.

Sorry for my bad english and thanks in advance !