Macro to copy and paste rows until blank comes

Emmanuel - Jan 16, 2016 at 01:03 AM

Can anyone help me to write macro code for the below condition.

I have data sheet which updates on a daily basis and no. Of rows with records will be increased.
I have other reference sheet with one row of formula built in.
Here I wanna update my reference sheet I.e, copy the entire built in formula row and paste until the row count of main sheet criteria met.

Thanks & Regards