Hi,

Our team is basically into Machine design and we use multiple toolbox component on day to day basis.

Fastener inserted in the assembly will be called out in the drawing using a unique number which our customer has generated in their database.

So every time when we create assembly drawing, there is a requirement for us to check in their database for that unique number.

So we have decided to create our own database for all tool box component (for all the sizes).

Requirement:

Is there any way where i can create a excel list with all tool box components file name + for all the sizes available. (DIN, ISO, ANSI, METRIC - these four standards are required).

I just need the description of the tool box component is a excel. Something like below.

For all sizes, all available length, File name is required.

Thread length can be ignored.

Please let me know if anyone can help on this.

Regards,

Prasanna.A