Macro to transfer column to row on another excel [Closed]

Report
-
Hi All,

Was stuck on this for a few hours yesterday. Read a few threads with solutions but I kept getting a debug popup window.

I'm trying to transfer all data in Column D in Book1 into a new row on Book2. The macro would be imbedded into a button at the end of Book1.

Can someone please help? thanks!

Book1 - https://uploadfiles.io/tcek7
Book2 - https://uploadfiles.io/h05ge