How to retreive datas form one sheet to another sheet in excel [Closed]

Report
-
 Blocked Profile -
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 reply


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?