Previous Topic Next Topic

Copy data from one sheet to other sheet.

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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 Nov 2014 à 06:50
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

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
How to copy sheets from one work book to other
Sultaaan -
venkat1926 -

1 response
How to copy data from one excel table to other
rkindia -
TrowaD -

1 response