I have a master list of information on one sheet with each row being one set
of information. I want to divide the rows into different sheets in the same
workbook based on certain critera such as a date. The information on the
master list will constantly be added to so copy/ paste is not really an
option. I can use an "if" statement to check one cell at a time but I need to
move entire rows of information. Is this something that can be done is excel
and if so, how?