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.
