Match Date and Copy Paste - Object Required Error

This

Please Login or Register  to view this content.

should either be

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Note that you don't need to select sheets. E.g.

Please Login or Register  to view this content.

is equivalent to

Please Login or Register  to view this content.

THANK YOU SOOOOO MUCH! it was just a silly mistake but you've helped me with my project soo much! thank you ! Thank you.

Here's the working code in case others run into this problem, I still have to clean up the ".Select"s but other than that it works.

Please Login or Register  to view this content.

Thanks Again SNB, but when I run this code nothing seems to happen. I'm looking to make this as clean as possible because I'm eventually going to have to copy and paste about 30 values over 6 workbooks. in the same fashion, by finding the right date reference. Am I implementing the code correctly? I've created a new module in VB and enter the following code. But, upon running , nothing happens? Also, I took out the Resume on Error, because If there was an error I wanted to know. I'm still not confident enough in my coding.

Please Login or Register  to view this content.

Now I'm getting a "Object Variable or With Block Variable Not Set"

Could it have something to do with the ", ," within the find function?

the Code below is what I'm trying to Run

Please Login or Register  to view this content.

I may have confused you - see my later edited revision above.