VBA code to hide rows based on a date

Hello: I have been almost an entire day at the computer looking for a VBA code to hide rows. Every one I have tried has failed.
In the attached, I would like a macro that copies 'Booked Orders' worksheet, creates a copy named 'Orders In Whse'. It should be able to over-write 'Orders In Whse' every time the macro is run.

Next I would like it to look at columns B & C, and hide the rows where both date columns are an earlier or same date as the current date (Now).

The code I had started:

Please Login or Register  to view this content.

I have attached a sample file.
Thank you so much!!!

P.S. If anybody could recommend a book for a VBA novice like me, I would appreciate it!

Sounds easy enough, but could you clarify two things first?

Is there a reason you need to copy the sheet rather than just copy the data over?
Is there a reason you need to hide the rows rather than just copy the relevant rows (the ones that would be visible after hiding the others) to the second sheet?

BSB

For example, try this:

Please Login or Register  to view this content.

BSB

Hi Badly: I just want it to look nice. I was using a formula to copy data, but it was not presentable as a report for employees to use. That's why I thought of copying the main report (worksheet) first.
Rows do not need to be hidden, just want to see the appropriate ones.
Thanks for the code below! I will try it and report back!

Badly: I tried your code, and it worked! I did give an incorrect operator for column "C", it should be >=.
Something did come up, though. I realized that some values in Column C in my full worksheet will be blank. In that case, I still want them returned in the "Orders in Whse" sheet.
So, I tried to alter the code as below, but it did not return any rows. Any suggestions to include blanks in column C as well?
Thanks so much!

Please Login or Register  to view this content.

It Worked!!!! Thank you so much for all of your help!

No problem at all. Glad I could help out.

BSB