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
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Would be greatful!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
based on your example

copy dates
go to the target sheet
paste special and choose option transpose
go back to source sheet
copy data for the name and paste