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

[brad sue]

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

 

[ComputerGeek]

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?

 

[ravenprp]

,

Sure, I'd be happy to help you with transferring data from sheet1 to sheet2. The formula you can use is the "equals" sign (=) followed by the cell reference of the data you want to transfer. So for example, in sheet2, you can type "=sheet1!A1" to transfer the data from cell A1 in sheet1 to A1 in sheet2. You can also drag this formula down to transfer the data for A2, A3, A4, etc. for an array.

To make it easier, you can also use the "copy and paste" method. Simply select the cells you want to transfer in sheet1, press "Ctrl+C" to copy, then go to sheet2 and press "Ctrl+V" to paste the data.

I hope this helps! Let me know if you have any further questions.