How do I create a macro which hide dates, copies information to another worksheet?

[naixiaki]

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!

[pierre08]

For the date to hide the row if a range contain a date lesser that today:

Please Login or Register  to view this content.

To sort a colomn bu ascendung order:

Please Login or Register  to view this content.

To copie the entire row to another worksheet if the colomn C says NOT RECEIVED

Please Login or Register  to view this content.

To copie the entire row to another worksheet if the colomn D does not equal to COMPLETED

Please Login or Register  to view this content.

here i think this should do it

[amandim]

hello ,
i am new to this forum and really need help this time as it is very urgent. please hekp me

I WANT TO RECORD A MACRO FOR

I MAKE CASH RECEIPT IN EXCEL WHICH CONTAINS
NAME
RECEIPT NO
AMOUNT
NAME

I WANT THIS DATA TO COPY IN ANOTHER SHEET OR ANOTHER WORKBOOK TO SAVE SEQUENTIALLY AS WHEN I MAKE ONE RECEIPT IT IS SAVED IN ANOTHER SHEET AND THEN WHEN I MAKE ANOTHER RECEIPT THAT WILL BE SAVED AFTER THE FIRST ONE AND LIKE WISE ALL THE RECEIPTS.ONE BY ONE TO KEEP THE RECORD EOF ALL THE RECEIPTS AFTER PRINTING.

I MADE A CASH RECEIPT FORMAT AND I WANT TO DO THIS L. HELP ME.
THANKS IN ADVANCE.