VBA to copy specific data from one workbook to another based on today's date?

Update...I no longer need to have a date parameter - I just need my code revised to copy from one workbook to another, rather than one worksheet to another.

Thank you!!!!!

Hello,

This is my first post to this forum (be kind! ) and I am relatively new to VBA and need some help. I am currently using VBA to copy specific data from one worksheet to another, but would like to change it to copy the same specific data from one workBOOK to another. My workbooks are named "PM-Test" (source) and "Changes"(destination).I really hope someone can help me! The code I am using currently to copy from one sheet to another follows. Thanks in advance for your assistance!

Please Login or Register  to view this content.