Copy data from one sheet to other sheet

Closed
Report
Posts
4
Registration date
Wednesday November 19, 2014
Status
Member
Last seen
November 19, 2014
-
Hi guys! I have a problem coping data from one row within a specific range, example A2, B2, C2, D2, E2 and so on up to P2, and copy that data to diffrent cells in column, B in another sheet, example B1, B2, B3, B4.....

Is there a way to create a formula, make a macro or make a diffrent setting to the program for making the transfer more easy?

Posting a example file:

http://s000.tinyupload.com/index.php?file_id=35658383826475072526