EXCEL SEARCH OPTION

[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

 

[VENKAT]

if you right click on the leftmost arrows on the tab line you can see all
the worksheets.

 

[VENKAT]

if you right click on the leftmost arrows on the tab line you can see all
the worksheets.

 

[Rachel]

Can I ask you an additional question offline relating to
Excel.

 

[VENKAT]

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.