The macros in the attached file do as they should. The only issue is that the Copy_Filtered() and Copy_Filtered2() macros copy too much that is needed and when pasting to another tab results in a larger file size.
Macros: FILTER
Filters the data in the BEA Dump tab by criteria. Once it is filtered, it calls Copy_Filtered() which should only copy the filtered data. However, it copies from B3 and every visible cell.
Than, filtered data is unfiltered and filters again by different criteria. Once it is filtered, it calls Copy_Filtered2() which should only copy the filtered data. However, it copies from B30 and every visible cell.
This overlap and the pasting of all I feel is resulting in a larger file size. What I would prefer is that the Copy_Filtered() and Copy_Filtered2() macros only copy/paste the filtered data respectively.
I've tried to find a way, but have not resolved the situation. Can someone look into the macros and see how that can be resolved?
Bookmarks