hello..

i've tons of data to filter, edit daily and i'm trying to create a marco which does the following:

1. hides the entire row if a certain column (eg. column B) has a date which is lesser than today

2. sort a column (eg. column A) by ascending order

3. copies the entire row to another worksheet if column C says NOT RECEIVED

4. copies the entire row to another worksheet if column D does not equal to COMPLETED

appreciate if someone can help!

thanks!