I want to copy range C2:I2 in SHEET 1 and paste these in SHEET 2 in range
B2:B10. I also want to repeat this macro by copying and pasting subsequent
ranges in SHEET 1 into SHEET 2.

Someone please help as I've got a cell range of 500 to copy and paste into
SHEET 2. I'm using Excel 2007.

Thanks