Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to auto populate stuff from one sheet to other linked sheet. e.g. If i enter something in one then it automatically populates in the next sheet. how i can do it
Solved by M. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/09/2018 - 12:49
Welcome to ExcelChat!
User 06/09/2018 - 12:50
Hi...i need to autopopulate stuff from one excel sheet to next like if one sheet has something added to it..it directly gets autopopulates on next sheet
Excelchat Expert 06/09/2018 - 12:51
In which places do you want to do that?
Excelchat Expert 06/09/2018 - 12:51
Or you just want to learn how to do that in general?
User 06/09/2018 - 12:51
in general
Excelchat Expert 06/09/2018 - 12:51
Can you see the sheet near the chat?
User 06/09/2018 - 12:52
no
Excelchat Expert 06/09/2018 - 12:52
Probably something is blocking it.. Have you worked with Excel before?
User 06/09/2018 - 12:52
yes
User 06/09/2018 - 12:53
can you tell me the steps
Excelchat Expert 06/09/2018 - 12:53
Okay, can you open Excel file first?
User 06/09/2018 - 12:53
yes
Excelchat Expert 06/09/2018 - 12:53
On Sheet1 in A1, please enter any text or number
Excelchat Expert 06/09/2018 - 12:54
Done?
User 06/09/2018 - 12:54
done
Excelchat Expert 06/09/2018 - 12:54
Now open Sheet2
User 06/09/2018 - 12:54
ok
Excelchat Expert 06/09/2018 - 12:54
And activate A1 on it
Excelchat Expert 06/09/2018 - 12:54
Press the = symbol on your keyboard
Excelchat Expert 06/09/2018 - 12:55
Now left click on Sheet1
Excelchat Expert 06/09/2018 - 12:55
And then on A1
Excelchat Expert 06/09/2018 - 12:55
And hit the enter button
Excelchat Expert 06/09/2018 - 12:55
You should get a formula like this:
Excelchat Expert 06/09/2018 - 12:55
=Sheet1!A1
Excelchat Expert 06/09/2018 - 12:56
Instead of clicking with a mouse it is possible just to type the address in the formula bar, but with mouse it is more practical in most cases, because we usually need to see the sheet to pick the proper cells
Excelchat Expert 06/09/2018 - 12:56
Please, share your results. If you have a problem, please mention on which step did it go wrong, I will help with it
User 06/09/2018 - 01:00
cool
User 06/09/2018 - 01:00
thanks
Excelchat Expert 06/09/2018 - 01:00
Great! I will send you a file, please wait for one minute
Excelchat Expert 06/09/2018 - 01:02
[Uploaded an Excel file]
Excelchat Expert 06/09/2018 - 01:02
This file contains Sheet1, Sheet2 and Instruction Sheet
Excelchat Expert 06/09/2018 - 01:03
Wish you a great day! If you don't have more questions, could you please end and rate the session? Thank you!
User 06/09/2018 - 01:08
wat if we need to do it for whole sheet like to add new stuff in one and it gets updated on next
Excelchat Expert 06/09/2018 - 01:08
Okay, please extend the session
User 06/09/2018 - 01:08
how to do
Excelchat Expert 06/09/2018 - 01:08
There should be a pop up
Excelchat Expert 06/09/2018 - 01:09
Maybe it is blocked in your browser as well..?
Excelchat Expert 06/09/2018 - 01:09
In 30 seconds you won't be able to chat if don't extend it
Excelchat Expert 06/09/2018 - 01:09
I can't do that for you :(
Excelchat Expert 06/09/2018 - 01:09
So I will just explain how to do it

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.