Zach
Member
The attached file is a schedule that I'd like to create a cleaner macro to have it shrink down data to show only the yellow data rows and the dark blue header rows basically starting at row 10. everything above row 10 can stay. I used the recorder to manually create the macro but there has to be a cleaner way to do it. I have a master column that shows the color requirements per row and I use that in the other macros. Can a macro be created to read that column and hide cells to create a Master Summary tab?