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?


Similar discussions

Copy worksheet from one workbook to another workbook in MS Office Excel
SrinivasNittala -
ac3mark -

1 response
Automatically transfer data from one sheet to another
sunny49er -
TrowaD -

22 responses
Copy data from one Excel sheet to another: automatically
gannesh0604 -
vcoolio -

10 responses
Automatically transfer data from one worksheet to another
vamus21 -
vcoolio -

1 response
How to report a defamatory account on Instagram
Anna -
Abhishek0025 -

8 responses