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?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!