Dividing Data between sheets in a workbook
 

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?

Dividing Data between sheets in a workbook
 

Why not just leave all on one sheet and filter
datafilterautofilter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jenny" wrote in message
...
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?