Search results for query: *

Thanks I now have a complete table of the 2,6082 gear combinations with the restrictions on gear sizes for position A. i.e. A B C D 1 30 35 120 30 2 30 90 90 40 Now, there is only one gear of each tooth size so I have to eliminate duplicates – or at least identify where they are. I...

Sorry I meant to say that the macros worked fantastically. However, the orignial intent was to have a simple screen where the machinists can input the thread pitch required and see the gear options. Anyway to do that with the macro? It is excellent as is though and the data sheets when sorted...

That's great! Now I know this must sound thick but how do I apply that to my spreadsheet?

Thanks Skip I may not be following you but I need EXCEL to give the the possible combinations of values for A, B, C, D which result in X.

This a problem dealing with choosing gears for a lathe to give a certain Thread per inch (and of course it's a non standard, no longer produced machine that has no manuals). ABCD are the gear positions and the values are the gears (tooth count) available. I want to give a value for X (threads...

Hello : First I'd like to thank all contributors out there I've learned a fantastic amount just lurking here. This is a really great learning tool. But now I'm stumped. I've used the techniques described above to auto populate from a combo box but cannot get the data to store in the the...