EXCEL SEARCH OPTION

  • Thread starter Thread starter RACHEL
  • Start date Start date
R

RACHEL

Hello,

I have create a spreadsheet with a lot of companies name
and contact representatives information. However, I have
several worksheet tabs and some of the names I can't see
because of the length of the list. I would like to have
some type of search option vailable im the spreadsheet is
possible, so that all that I would need to do is type in
the persons last name or companies name and it would
automatically pull up the Companyies information.

Cheers,


Rache
 
if you right click on the leftmost arrows on the tab line you can see all
the worksheets.
 
if you right click on the leftmost arrows on the tab line you can see all
the worksheets.
 
try something like this

Public Sub test()
Cells.Find(what:=InputBox("type the name of the
company/lastname")).Activate
End Sub

you will get input box there type the name of the company or last name.
that partiuclar cell wil be activated in the spreadsheet.
 
Back
Top