After hours or struggle (albeit a great learning experience), I finished the below Macro. The macro basically checks a column for text in each cell, and if text has been entered, it copy's and pastes special the line (s) on a new sheet. The issue I am having is that I have slicers in column A...