Previous Topic Next Topic

Copy from one excel sheet to another

Closed
sutch Posts 2 Registration date Friday December 28, 2012 Status Member Last seen December 31, 2012 - Dec 28, 2012 at 12:55 PM
sutch Posts 2 Registration date Friday December 28, 2012 Status Member Last seen December 31, 2012 - Dec 31, 2012 at 01:02 PM
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

Answer 1 / 1
Jean-François Pillou Posts 19261 Registration date Monday February 15, 1999 Status Webmaster Last seen February 16, 2023  
Dec 28, 2012 at 03:23 PM
This could help you:
https://ccm.net/faq/6033-excel-copy-data-from-one-sheet-to-another
sutch Posts 2 Registration date Friday December 28, 2012 Status Member Last seen December 31, 2012
Dec 31, 2012 at 01:02 PM
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.