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 'ChatGPT Examples, Good and Bad'

Thread 'ChatGPT Examples, Good and Bad'

I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...
View full post »

Thread 'MS 365 Profile Badge colour'

Sorry if 'Profile Badge' is not the correct term. I have an MS 365 subscription and I've noticed on my Word documents the small circle with my initials in it is sometimes different in colour document to document (it's the circle at the top right of the doc, that, when you hover over it it tells you you're signed in; if you click on it you get a bit more info). Last night I had four docs with a red circle, one with blue. When I closed the blue and opened it again it was red. Today I have 3...
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
5K
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
1K
How to calculate all the possible combinations....?
Replies
17
Views
3K

Hot Threads

Recent Insights

Back
Top