Complicated copy

[wiwchar]

I have a need to create a complicated series of cell copies (atleast complicated to me). In Sheet1, I have info in cells A5 to B40. In Sheet 2, I need to take the info from Sheet1!A5 and place it into Sheet2!E2. This is straight forward. Next, I need cells Sheet2!F2 to Sheet2!K2 to have the same information. After that, Sheet2!L2 needs the info from Sheet1!A6 and then Sheet2!M2 to Sheet2!R2 needs the same info. This is to repeat until there is no more info in column A of Sheet1, which in this case happens to be row 40.

I need to then create the same pattern in Sheet2 row 3 pulling the information from Sheet1 column B.

Any assistance with this is very much appreciated.

Thanks in advance.

 

[wiwchar]

Any ideas out there?