Or you can get creative using the Data Filter Autofilter Custom
"contains"......it will do some really neat things...........

Vaya con Dios,
Chuck, CABGx3




"Tricia LeAnn" wrote in message
...
Ok. That makes sense. So then do I just use "Find" under the Edit menu to
find the references?

Thank you so much for all of your help. It is greatly appreciated. Heck,
you might even be helping me get a raise! :)

"CLR" wrote:

In A1 put PARTNUMBER
In B1 put DRAWINGNUMBER
In C1 put TUBENUMBER
In D1 put DESCRIPTION
In E1 put DATE
In F1 put REMARKS
Note: you can change the order of the columns to suit..........

In A2 put 105610
In B2 put 156-C-102
In C2 put B
In D2 put a description of the part
In E2 put some representative date, today if nothing else
In F2 put any short remark that will help locate the part, or whatever

Then in row 3 you can enter the next part, etc etc............

Just remember to save every so often so you won't lose everything if
something goes wrong.......

Vaya con Dios,
Chuck, CABGx3

In A2 put 105610
"Tricia LeAnn" wrote in message
...
Ok. One more thing.

Here is an example of what I have to do. Can you tell me how to put it
into
excel?

Part #105610 is also Drawing #156-C-102. Those are the 2 numbers we
use to
locate the tube numbers or letters. The tube letter for this
particular
part
#/drawing # is Tube B.

"JP" wrote:

Unfortunately if all you have are notebooks, you will have to assign
someone the manual work of typing in the part numbers.

What you could do is put the part number in column A, and the
corresponding tube location/name in column B, you could use a
VLOOKUP
formula to assist you.

For example, enter the part number in C1, and in D1 put
=VLOOKUP(C1,A:B,2,FALSE) to return the corresponding tube name for
the
part number you entered in C1.

Without having an example or any more information about your
problem,
this is all the assistance I can provide at this time.


HTH,
JP

On Jan 15, 9:53 am, Tricia LeAnn <Tricia
wrote:
I work at a place where we have tubes that hold old engineering
drawings.
Anytime we need to retrieve one of the old drawings, we have to
search
through notebooks looking for particular part numbers in order to
find
the
drawing we are looking for.

I thought if I could make a list of all the drawing numbers and
all
the
tubes, it would be a lot easier to be able to type them in Excel
and
find the
tube number instead of having to flip through 3 huge binders.

The only problem is, I have NO IDEA how to do this! If anyone
could
help me
I would greatly appreciate it!!

Best wishes- Tricia LeAnn