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?

Copy from one excel sheet to another
Transfer data from one excel worksheet to another automatically - Guide
How to screenshot excel sheet - Guide
Mark sheet in excel - Guide
Little alchemy cheat sheet - Guide
How to open excel sheet in notepad++ - Guide

1 response

Answer 1 / 1

Jean-François Pillou Posts 18707 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.

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet

Similar discussions

Subscribe To Our Newsletter!