How can I reference the active cell within a loop through different sheets?
I am stuck where it is properly reading that I have two rows that fulfill the “If” condition, but it is copying row A both times on separate sheets, rather than row 8 and 10. Is there a way to have it recognize one cell at a time and copy it if it fills the conditions.