I need an algorythm that will search for a particular phrase in Excel file (f.e. a cell containing "Anna") and copy the value of the opposite cell to GridView that it to say synchronize two databases. Synchronising and copying the whole file will not suit me because every time the position of "Anna" cell (both row and column) will be unpredictable.
in Excel
Name - Phone number
Anna - 007655456586
Mary - 007945685675
in GridView ()
Name - Phone Number
Anna - ....
Mary - ....