excel search function

C

claudia1907

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:
 
C

claudia1907

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