excel search function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

claudia1907 - 05 Sep 2005 09:09 GMT

i created a big excel file with many sheets. in every sheet (except
sheet 1 and 2) is a special id number in column B. now i want to make a
search function on sheet 1 to get linked to the sheet (cell) where the
number-which i`m looking for, is. how can i do this?
heeellllp! :confused:

Signature

claudia1907

Reply to this Message

Don Guillett - 05 Sep 2005 13:56 GMT

I think I would prefer to name that cell, id1, id2, etc.

Signature

Don Guillett
SalesAid Software
donaldb@281.com

>
> i created a big excel file with many sheets. in every sheet (except
> sheet 1 and 2) is a special id number in column B. now i want to make a
> search function on sheet 1 to get linked to the sheet (cell) where the
> number-which i`m looking for, is. how can i do this?
> heeellllp! :confused:

Reply to this Message

claudia1907 - 06 Sep 2005 08:50 GMT

the column already have a name and it is C-Number!
so once again: i want a link/search function on my first sheet, that
when i put in a C-Nmuber (for example 50-002-2) i will be linked to
that special shett/cell with this number in.
dont know how to do this for many many sheets/columns.

Signature

claudia1907

Reply to this Message