CODEWITHSUNDEEP
excel
Elijah Leis
Elijah Leis

Reputation: 25

How to automatically update each sheet in Excel

I'm curious to ask if there is a way to automatically update the data that is beeing copied from sheet 1 to sheet 2? like for example if i add a data on sheet 1 it will automatically add in sheet 2?

For example, I have this one sheet that i'm storing my data: enter image description here

Now I can use the data in there by typing the ='<sheet_name>'!<column/row_number> in the formula, which achieves to update it when ever i changed the values it is connecting to sheet 1, but if i add another row in sheet 1 it doesn't automatically update in sheet 2 unless i clicked the small box icon when selecting a cell.

Is there any way to automatically achieve this so whenever i add a data on my sheet 1 then that data will automatically show in sheet 2?

Any help will be appreciated.

Upvotes: 0

Views: 114

Answers (1)

user17291846
user17291846

Reputation:

Copying Sheet1 data of A1 to Sheet2 A1

=Sheet1!A1

Copying in the same file but between different sheets:

=Sheet_name!Cell_address

Copying in different files and between different sheets:

=[Workbook_name]Sheet_name!Cell_address

For more visit Microsoft Page.

Upvotes: 1

Related Questions