Irenus Kassii

Irenus Kassii

  • NA
  • 1
  • 654

How to search for a particular phrase in Excel and copy it ?

Jun 3 2015 11:15 AM
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 - .... 
 

Answers (1)