Hyde
Yep ... I COULD do that, but think about who the list is intended for ...
Are they familiar with Excel? Maybe. And to populate a hugh spreadsheet would take thousands of man-hours. I have Excel spreadsheets that have over 50 macro and thousands of hours of work.
I was thinking of something like you did with the drop down boxes, but I'm afraid that tons of work in Excel might be a waste of time for the people who are Excel ignorant. Maybe not?
But anyone can read a PDF list and click on tabs and go to the web site of that manufacturer. At least that will get the newbie to first base. Once we get to that point, we can maybe work on a grand-slam spreadsheet