Copy from one excel sheet to another

[Closed]
Report
Posts
2
Registration date
Friday December 28, 2012
Status
Member
Last seen
December 31, 2012
-
Posts
2
Registration date
Friday December 28, 2012
Status
Member
Last seen
December 31, 2012
-
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 reply

Posts
18651
Registration date
Monday February 15, 1999
Status
Webmaster
Last seen
September 22, 2021

This could help you:
https://ccm.net/faq/6033-excel-copy-data-from-one-sheet-to-another
Posts
2
Registration date
Friday December 28, 2012
Status
Member
Last seen
December 31, 2012

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.