How Can I Transfer Data from Sheet1 to Sheet2 in Excel?

  • Thread starter Thread starter brad sue
  • Start date Start date
AI Thread Summary
To transfer data from Sheet1 to Sheet2 in Excel, users can utilize simple cell references. For example, entering "=Sheet1!A1" in Sheet2's A1 cell will copy the value from Sheet1's A1. To transfer a range of cells, such as A1 to A4, users can drag the fill handle after entering the formula in the first cell. The discussion also raises a question about whether the context involves Excel sheets or arrays, indicating some confusion. Clear instructions and examples are requested for better understanding.
brad sue
Messages
270
Reaction score
0
Hi please,
I would like to have some help:
I woul like to transfer data from sheet1 to sheet2.

For example , if I have in sheet1

A1=12
B1=15
C1=5
D1=8
E1=9

And I want in sheet2:

A1=12
B1=15
C1=5
D1=8
E1=9

Please give me the formula. I did some research, but I did not understand what they were talking about!

Please Give me also the formula for A1, A2, A3 A4 (for an array) from sheet1 to sheet2
Please Be precise..

Thank you

Brad
 
Computer science news on Phys.org
brad sue said:
Hi please,
I would like to have some help:
I woul like to transfer data from sheet1 to sheet2.

For example , if I have in sheet1

A1=12
B1=15
C1=5
D1=8
E1=9

And I want in sheet2:

A1=12
B1=15
C1=5
D1=8
E1=9

Please give me the formula. I did some research, but I did not understand what they were talking about!

Please Give me also the formula for A1, A2, A3 A4 (for an array) from sheet1 to sheet2
Please Be precise..

Thank you

Brad

is this an excel sheet? or are you just talking about two arrays?
 

Thread 'The Human Cost of AI'

This week, I saw a documentary done by the French called Les sacrifiés de l'IA, which was presented by a Canadian show Enquête. If you understand French I recommend it. Very eye-opening. I found a similar documentary in English called The Human Cost of AI: Data workers in the Global South. There is also an interview with Milagros Miceli (appearing in both documentaries) on Youtube: I also found a powerpoint presentation by the economist Uma Rani (appearing in the French documentary), AI...
View full post »

Similar threads

I Physics domain analysis of Voltage drop in series resistor
Replies
7
Views
2K
Autocorrelation function in Excel
Replies
1
Views
5K
How to Use REGEXMATCH for Highlighting the Current Month?
Replies
2
Views
1K
Algorithm for creating unique groups of elements
Replies
1
Views
2K
Superscript Formula in Excel Function CONCATENATE
Replies
5
Views
14K
I Measurement problem in simple experiment
Replies
38
Views
6K
I Formal derivation of statement from Peano Arithmetic system
Replies
10
Views
241
How Can I Find the Cubic Spline Function for This Data?
Replies
1
Views
1K
MCNP6 Reproduction of 40 MeV D - Li Target Experiment
Replies
1
Views
2K
Comp Sci An Introduction to Deep Learning and Modifying Code
Replies
7
Views
2K

Hot Threads

Recent Insights

Back
Top