I need a mcro that would copy specific ranges of cells from sheetA in
WorkbookA.xls and paste-special the values into specific range of cells
in sheetB of WorkbookB.xls using an *interesting* pattern as follows--

-The macro should start by copying range E4:N10 of sheetA in
WorkbookA.xls and paste-special the values in cell E4 of sheetB in
WorkbookB.xls

-Then copy range E12:N18 of sheetA in WorkbookA.xls and paste-special
the values in cell E12 of sheetB in WorkbookB.xls

-Next, copy range E20:N26 of sheetA in WorkbookA.xls and
paste-special the values in cell E20 of sheetB in WorkbookB.xls

-Then copy range E28:N34 of sheetA in WorkbookA.xls and paste-special
the values in cell E28 of sheetB in WorkbookB.xls and so on.

*** Now you see the pattern. This macro should continue this copy and
pste-special values process in this pattern all the way down till there
is nothing to copy and paste.

Any assistance would be greatly appreaciated. Thanks!

Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!