How to transfer data to another work book in excel

Closed
Surya - Feb 22, 2017 at 09:37 PM
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.