Ask your own question, for FREE!
Computer Science 21 Online
OpenStudy (anonymous):

Hi everyone, could all of you help me in MS-Excel: Example: In sheet1 I input the data and I want that data appear in another sheet (sheet2). Thank your for your advice.

OpenStudy (anonymous):

In a simple way, just copy the input data in sheet1, then move to sheet2 and paste it there

OpenStudy (espex):

The basic format is ='Sheet title'!cell Let's say you have a sheet titled "Sheet 1" and another titled "Sheet 2", and you would like the data entered into cell C7, on Sheet 1, to appear in cell A2, on Sheet 2. Click on cell A2, Sheet 2, and type ='Sheet 1'!C7 then hit enter, now any data you enter into Sheet 1, C7, will appear in Sheet 2, A2.

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!