hi
Based on what you have posted, i think you have a large project ahead of you.
the three binders you mentioned. you will have to enter all of that into the
xl file.
yeah, i know.....HUH!!!!!
I would be nice if you drawings and tube were bar coded. that would really
speed up input. or if you could download....but that would mean that someone
else has already done the input.
enter the data by drawing numbers in a column and it's corrosponding tube id
on the same row. include the drawing discription.(few people commit id
numbers to memory but discripiton are easier to remember.) include other info
that might be usefull. like dates of drawings and anything else that might
help id the drawing.
and each time you have a new drawing.....new entry
you can then use a number of xl tools to find the info.
Find..filter..sort...other.

Good luck.
Regards
FSt1
You can then use a number of

"Tricia LeAnn" 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