Is there a function or command I can use to get excel to automatically copy a
row from the master worksheet over to a seperate monthly sheet when the data
in a certain cell matches a range of criteria
i.e.
Master (Wksht 1)
A B C
Joe Smith Active 11/01/07
John Doe Closed 11/10/07
Justine A Pending 11/08/07
Kim Al Active 12/07/07

Monthly (Wksht 2)
A B C
=the entire row if cell C is within 11/01/07 - 11/30/07