Automatically Update Data in Another Excel Worksheet or Workbook - 3 Methods

------------------------------------------------------------

So you want to automatically refresh data in another Microsoft Excel workbook or worksheet. This video explores three methods for how this can be achieved: cell referencing, table referencing and Power Query.

Table of Contents:

00:00 - Introduction
00:34 - Using sheet cell references to link and update across worksheets
02:20 - Copy and paste links to link and update across worksheets
03:18 - Link and update across workbooks using cell references
05:26 - Using cell references to auto update new or amended records
07:48 - Using tables to link and update data across worksheets
11:31 - Using tables to link and update across workbooks
12:57 - Using Power Query to link and update across worksheets
16:10 - Using Power Query to link and update across workbooks
------------------------

[BalkanOkami]

Didn't end up being the precise workflow I was looking for, but I still watched the whole vid because of how clear and useful it was!

[lolacanna]

Thank you for showing all three! Most I have found have only shown the first and most common. Your video should be at the top of the list!

[tameracingdriver]

You sir are a lifesaver. I am not at all good with Excel but have recently been given tasks to do in it and didn't know where to start. You can't even begin to imagine how helpful this has been. Thank you!

[omjgnum]

Explained in a easy manner, thank you so much.

[silviopoggi]

Brilliant as always. Thanks so much for your time...

[IvanCortinas_ES]

Thank you Chester. A great explantion.

[samplayingkeeps]

This was extremely helpful. Thank you so much!

[su-megalotto]

Thank you for the video, I can use the different methods as needed. the information was given with very clear steps for each method.

[harman.]

It was a great help to me! All the methods have been explained pretty well.

[superdpor]

Chester, thanks. Simple explanation, easy to do!!!

[SASlair]

I learned something new today. Excellent tutorial! Thank you 🙂

[naufilzahid]

Excellent communication. Taught in a very easy to understand way.

[justmeva]

Great and useful information: thank you.

[ryanj]

9:14 I just spent all day trying to find how to do this one thing.
You have saved me ❤

[Jojosmith]

thumbs up as always for the very valuable lessons as always. Subscribed from the very 1st lesson. Thanks a lot Chester for your valuable time and hard work.

[robertoniga]

Great video, very heplful, it's sad they do not teach us these very useful tools in Universities. Thanks a lot!

[TrungTran-ssmt]

Thank you, the video is very helpful for me.

[wkzbtni]

Excellent Information Sir! Very helpful. Thank you so much!

[dgddktk]

Great explaination, thank you. Can you use this method to create new columns with specific formulas?

[havaljamal]

thank you indeed for your session it was very useful.