Userform 1
is put data into worksheet
Put in name in box than press Search button highlight person where is locate at on
Worksheets. On form where say type put
C for Cell
H for Home
F for Fax
On worksheet where stay type will put
Cell
Home
Fax
Some reason it skip a line I not sure why skip
Userform 2
is to view what on worksheets type in a name than press Search button bring person data into form
Give sample you type in first Name like "Thomas" press search bring all with same name some next one
The picture is for userform1
Bookmarks