Hi, I'm new to the group and have hit a wall writing a macro. I am trying to create a Bill of Material Macro for work, breaking the BOM down by size and separating everything into different sheet tabs. It all seems to work fine until it tries to filter and sort my second pivot table. I attached two files, the test file is pre-macros and the template file is where I created the macros, as well as the macro text. Not sure if I do it correctly, I always create two files. One to show how I want it to be while creating the macro, and the second to do a test run before creating the button for me and the guys I work with. Any help would be greatly appreciated. Please let me know if any further information is needed.