EXCEL SEARCH OPTION

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RACHEL - 11 Sep 2004 20:26 GMT

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

Reply to this Message

VENKAT - 12 Sep 2004 02:01 GMT

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

> Hello,
>
[quoted text clipped - 10 lines]
>
> Rache

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

Rachel - 12 Sep 2004 15:40 GMT

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

>-----Original Message-----
>if you right click on the leftmost arrows on the tab line you can see all
[quoted text clipped - 15 lines]
>>
>> Rache

Reply to this Message

VENKAT - 13 Sep 2004 07:07 GMT

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.
--------------------------

> Can I ask you an additional question offline relating to
> Excel.
[quoted text clipped - 25 lines]
> http://www.opera.com/m2/
>> .

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

VENKAT - 12 Sep 2004 02:01 GMT

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

> Hello,
>
[quoted text clipped - 10 lines]
>
> Rache

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message