dear friends,
on 26.05.2015 i posted this inquiry where NAVEED RAZA assisted with VB coding and solved my requirement. attached is the exel file that NAVEED RAZA produced.
now i would like to do the following and hope you can assist me plse... thank you.
1. in the ACTUAL LIST sheet once a name is typed and entered the result is produced by the name and passport no. i would like to expand this to include the nationality as well. therefore once search is entered the result should consist of name, nationality and passport no.
2. once the above is performed (search), we then select the name and press ENTER. once this is done the appropriate name is listed in the ACTUAL LIST sheet. at this moment, what i also want is that this particular name is highlighted in the NAMES sheet as well. for example, if i select and enter say 5 names in the ACTUAL LIST sheet and when i press the cursor at the first NAME column, this name with details should be highlighted in the NAMES sheet. then i press the 4th name in ACTUAL LIST sheet and in the NAMES sheet this particular name row should be highlighted.
look forward to hear from you and thank you very much
best regards
rizvi
Bookmarks