I am trying to come up with a macro that will copy the data from a worksheet name "CPHP060908" (date changes daily) and paste it into a seperate master workbook to a tab named "CP HP". If anyone has any idea how this can be done I would greatly appreciate it. I know it is probably a very easy fix but as usual I'm trying to make it too complicated.
Thanks in advance!
Bookmarks