need some help. i have a folder with a spreadsheet and some tif drawings. the drawings are specific to a part number on the spreadsheet. i need to find a way to link the drawing to the part number on the spreadsheet. i know how to do it one at a time creating a hyperlink but i have over 200 drawings i need to link to the specific drawing. drawing name is the same as the part number on the spreadsheet. is there an easier way then doing it one at a time. i'm using Excel 2000. Help!!!!