Copy cell query
 

I have a worksheet that has loads of data.

How do I select a certain cell say A1 as a start point and then copy the
cells 51 cells across and 9 cells down. I then want to paste this data into
a second workbook on say sheet 1 cell A1.

I then want to return to the original file and worksheet and copy from cell
J1 and copy the cells 51 cells across and 9 cells down and then paste this
into sheet 2 cell A1 of the second work book.


All told I want to copy the same sized chunks of data from the original file
(from different starting points) a total of 70 times into 70 seperate
worksheets in the second workbook (the cell reference will always be the
same on the seventy worksheets in book 2) - would some form of loop be
required? i also want the code to be in a module on the file the data is
being pasted into.

Any help appreciated

Cheers

Gazza