Import data from source to target

Hello All,
My Goal is to import data from another workbook (Source) to Active Workbook (Target) while reading through all the "filtered" data on the Source Workbook (Row 13 and beyond to say 5000 rows max) while only importing the Product # (column A on both sheets) and the ordered Qty from the Source Sheet (Column M) to Ordered Qty on the Target (Column D). I've got a limit of occurrences that can occur on the Target Workbook of 501 possible lines of items that can be ordered. Max should be around 300 but, 501 is a safe range for future. Initially everything worked great and brought everything across throughout the entire range of 501 but, it even brought the filtered out blanks data as well (which is what it was spose to do). I need to read through each Product and Qty Ordered from the Source Workbook while skipping that row and going to next if the Ordered Qty is "" (blank)....and most likely filtered not to show. My initial code above does not take into account possible filtered blanks rows in between the ones I tested and I thought of that as I was typing this response so, I'd need to add that in as well. I'm having current issues where noted Error and ****** to note it.
TIA, khleisure

Please Login or Register  to view this content.

Moved Query/Question to precede posted code above