See the attached workbook. I'm pretty close. I can get the first highlighted row in the first worksheet the code encounters to copy over.
There is a problem somewhere with the looping.
Perhaps a fresh set of eyes will be able to help.
The code runs fine the way it is. There are no error messages so I'm not sure where the code it going wrong.
Bookmarks