How to transfer data from one Excel sheet to another?
Read this short guide if you would like to transfer data between two Excel spreadsheets. We will show you how to bind data from a column to a row in another sheet.
How to transfer data between two Excel spreadsheets?
Consider that the data to be copied are on Sheet1! B2:H2 and and the targeted ones in Sheet2! C3:C9 (the number of cells are identical).
- Select the second range (Sheet2)
- Type = TRANSPOSE =TRANSPOSE(Sheet1!B2:H2)
- Confirm with CTRL + SHIFT + ENTER to obtain an array formula.
Note: Only the content is copied, to the format of the destination cells
How to transfer data on Excel via a command?
There is also a command that can achieve this manipulation:
- Copy/Paste > Paste Special > Transpose.
Do you need more help with Excel? Check out our forum!
Subject
Replies
Around the same subject
- Transpose data from one sheet to another
- Transfer data from one excel worksheet to another automatically > Guide
- Macro to copy data from one sheet to another based on criteria [solved] > Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download [solved] > Excel Forum
- Digital data transmission > Guide
- Excel copy data from one sheet to another if a condition is met > Excel Forum