I'm trying to get the sheaves to automatically create a filtered list dependent on selected motor and large sheave bore input on "user inputs" tab. the sheaves match based on bushing type or bore diameter. I tried to create the ranges for the sheaves lists using advanced filter based on table[#all] as list range, the listed criteria ranges listed in the criteria range tab and copy to lists tab. This ultimately did no work right, I also don't want "Item Number and Description" to show up in the list. I would like these ranges to update automatically If new sheaves or bushing get added to table 5 or bushings list. Can someone please help me out with tis or help give a different method of doing this. If this requires a vba macro I could really use help because I have very little experince in coding. This got handed off to me and I hardly understand the complicated nested index and match functions that popultate the selected bushing. Thank you
Bookmarks