Previous Topic Next Topic

Copy from one excel sheet to another

Closed
sutch Posts 2 Registration date Friday 28 December 2012 Status Member Last seen 31 December 2012 - 28 Dec 2012 à 12:55
sutch Posts 2 Registration date Friday 28 December 2012 Status Member Last seen 31 December 2012 - 31 Dec 2012 à 13:02
Hello,

I am trying to figure out if it is possible to copy from one sheet to another. Not the whole sheet, but rather I would like to put cells from one sheet into different cells on another.

example:
sheet one is all one row. I want A1 to go into cells A2 through A17 on the second sheet; I also want to put A4 from Sheet 1 into AX2 on sheet 2, etc. Is it possible to set this up so I can just add a new sheet 1 every time and it will populate sheet 2's cells?



1 response

Réponse 1 / 1
Jean-François Pillou Posts 18961 Registration date Monday 15 February 1999 Status Webmaster Last seen 16 February 2023  
28 Dec 2012 à 15:23
This could help you:
https://ccm.net/faq/6033-excel-copy-data-from-one-sheet-to-another
sutch Posts 2 Registration date Friday 28 December 2012 Status Member Last seen 31 December 2012
31 Dec 2012 à 13:02
thanks for the reply, but that code appears to copy from one sheet to another as a whole. I want to take a row and copy specific cells to different cells in another sheet. A1 to AU1; B1 to AV2, etc.

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