drag and drop files onto cells for hyperlinking?

Hi everybody,

I've been told at work to do a very tedious task. I have a series of items (300) and I must hyperlink each of them to a file ( a jpg, a descriptive picture of the item) located in the company server. Having to go through the Excel right-click menu for attaching each of this 300 files is exhausting. And drag&dropping the file from the windows explorer onto a cell doesnt seem to work for this purpose...isn't there a way ( via Macro?) to implement a drag&drop solution?

It's not so easy like writing a list of file-routes and associate it with my list of items, since I firstly must identify visually the item in the picture, and then link it with the file . Drag&drop is the best solution.

I use Excel 2010.

Thanks for your answers and suggestions in advance!