Hello!
I need help copying and entire row based on two criteria. I have a master sheet named "WC". I have 7 additional sheets named for their criteria.
I've been trying to write a formula that will search column N for a range of numbers and specific word in column O then copy the entire row into the new sheet if both conditions exist. For example, 25,000 to 99,999 from column N and 'Base' from column O.
From what I've seen the fastest way to do this is to use VBA; however, I have limited experience and was hoping someone could point me in the right direction. I've attached an example workbook.
Thank you in advance!
Bookmarks