copy specific cells from a worksheet to another

[bugntl]

i have a worksheet named "ORDER" and i want to copy the data
from cells C5:G24 to another worksheet named "Data"
on the next blank row

 

[Ron de Bruin]

Hi bugntl

Try this example
http://www.rondebruin.nl/copy1.htm