help finish/fix this code: copy non-blank cells to corresponding cell on another sheet

Here is a sample of the data I am working with. Cells A2:A11 are named "INV_ENTRY_LOG_LINE"

Sheet1.jpg

Here is a sample of the table. Cells A2:A14 are named "LOG_LINE", and the worksheet is named "PO_LOG".

Sheet2.jpg

Using the line numbers as a reference (columns highlighted in yellow), I'm looking to find a way to copy the non-blank cells in columns E:I on the first sheet, and transfer them to columns E:I on the other worksheet.


Here is the code I have so far, but line 4 doesn't work quite right and I'm not sure how to get it to behave.

Please Login or Register  to view this content.

Can someone help me fix line 4?

Hi,
Thank you for your assistance!

I took the code you provided, merged it with my original code, and all is working EXACTLY as needed; thank you so much!!!

Please Login or Register  to view this content.