**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.*