VBA to copy range from one sheet to another sheet

[tantcu]

Hello,

I need help for copying data from sheets(Data) starting from row C14 to the last row and copy it to row B35 of sheet Master. Then copy data from row E14 of sheets(Data) to row F35 of sheet Master.

Thanks

[stnkynts]

Please Login or Register  to view this content.

[Paul]

Will the following work?

Please Login or Register  to view this content.

[tantcu]

Thanks guy, if I just want to paste value only. How can I do that?

[Paul]

Please Login or Register  to view this content.

[tantcu]

Thank you so much