Copy data from one sheet to other sheet.

Closed
glukos Posts 4 Registration date Wednesday November 19, 2014 Status Member Last seen November 19, 2014 - Nov 19, 2014 at 11:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 22, 2014 at 06:50 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 22, 2014 at 06:50 AM
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
0