Check if Cell Value exists... If not copy into a different range

The following will check to see if value exists, if not then add it to the last row in column.
How I am using it is to find the Prj ID # in Column U on the Planning Tracker and if it does not exist in Column A on the PnL then add it at the end of the column.
But, I also need to include values from seven additional cells on the same row that correspond to the Prj ID

Please Login or Register  to view this content.

I found this which will execute the multiple columns of copy paste... it only updates the last row and stops. What I need is to add the last section in Bold/Italics to the above code, but cannot figure out how to do it

Please Login or Register  to view this content.

Please Login or Register  to view this content.