How to Automatically Update Data in Another Sheet in Excel

If you found this video useful make sure to hit that Subscribe button also click on the Bell icon to get notified every time I post a new video

Moreover, feel free to connect with me via LinkedIn and twitter

Link to my Career Website WWW.MEHRANVAHEDI.COM
LInk to my Blog (where you could find sample workbooks): WWW.WISDOMBYDATA.COM

Thanks for watching and I will see you on my next video

[jaedelarosa]

Will try this later at work. Thank you!

[david_sdiego]

Method 1 works like a charm. Great info -- thank you.

[zelhya]

the method 1 did not update my data but method two worked . thanks

[christianbattle]

Sadly this didn’t work for me once the data gets sorted since it’s still linked to the specific cell and not the data in the cell.

[anadealvarez]

Thank you for the explanation. I have a question: let's say that I want to sort the date on the Main Tab, for example, I want that the numbers in column B to be arrange from smallest to biggest. Once I do that, will the info in the other tabs also change?

[sallumank]

Hello sir thanks for informative video

[EbonieF]

How to link the 2 tabs, so that when resorting on the main tab, the correct value will still be reflected on the corresponding tab?

[aibincredibl]

Can you help me to do same things with datewise like every time I change date data will save next sheet datewise thanks

[ajay-I]

Could you help me regarding this doubt

I have 2 Excel files
First file having 10 customers data (unique ID no., name Age, salary).
Second file has 15 customers data (unique ID no., name Age, salary).
But both files have 7 common customers.


I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer.

Example:
If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.

[sallumank]

I have one doubt how to update data in master if we update in account sheet or claim sheet is there any way we can update in both sheet vise versa

[thestranger]

Hi, I've 3 workers who do certain number of cases each day. I want to know if it's possible to get total number of cases done by each worker along with name and date on a new sheet without using filters on the actual sheet

[subhamsaha]

for example if in main tab you insert a row which is "Accounts 3400", then how I can update the changes in another worksheet?

[csumanthreddy]

How to do it for multiple row.? Anyone?

[TheKarout]

method 1 doesn't work
and what good is this for, we want to add more records to another storage table, like new users names phone number, and more

[davidclapham]

What happened to cell a2 in sheesh 2 (=a2) in sheet 1 that's easy

[afnanshaikh]

GREAT EFFORT BRO BUT THIS DOESN'T SOLVE MY PROBLEM. AS I HAVE 1300+ SHEETS