Previous Topic Next Topic

How to retreive datas form one sheet to another sheet in excel

Closed
vinutha vagata - Updated on Dec 21, 2017 at 06:09 AM
 Blocked Profile - Dec 21, 2017 at 03:08 PM
Hello,

If having the datain one sheet per example A column and Values column data are entered ., in next sheet if i enter the A it has to show the data automatically..
Please i need help..
Help me with this


1 response

Answer 1 / 1
Blocked Profile
Dec 21, 2017 at 03:08 PM
In example, on sheet where you wish to display a put:
=if(Sheet1!a1<>"",Sheet1!A1)

Now on sheet1, in cell A1 place any digit. Now go to the sheet that you placed the formula in, does it equal A1?