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

Question

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


System Configuration: Windows / Chrome 63.0.3239.84

ac3mark · Answer

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?

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

1 response

Similar discussions

Subscribe To Our Newsletter!