How to transfer data to another work book in excel

[Closed]
Report
-
Hello,

I would like to automatically transfer the data to another work book but I do not want to transfer the rows that have blank data. could you please help us in this regards.