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

Explained in a easy manner, thank you so much.

thank you indeed for your session it was very useful.

Thanks for great video. How did you get rid of those zeros while sharing two workbooks?

Hi Chester, I'm wondering if there is a formula to link merge cells into a single cell.

Hi Chester, when I copy the entire column as reference it has the sheet name 'Sheet1'!RC all the entire column. I tried to replace RC as cell reference A1 but error message Name? how to fix this? thanks a lot

I have a costs file for fiscal year 2021, which is a huge file with complex data such as salaries, supplies, specializations, and other costs in tables. At the end is the ledger (GL). I want to upload additional data to the file, such as costs for the year 2022. How can I do that, knowing that the file was created by an external company? How can I add data, knowing that my device is a Mac?

Thank you so much - you are a life saver! This was so helpful and straightforward! Please keep posting. Question for you: I see that if you add/modify in the original table it will reflect in the linked table. Is there a way to also make that go in reverse?

This is a big help.
Do you know how to link cells from sheets 1-10 to another workbook on sheets from 1-10 as well.
Ex workbook 1 (sheets 1-10 cell B12) link to workbook 2 (sheets 1-10 cell B12)

Thank you, the video is very helpful for me.

Brilliant video! thanks a lot

can you pls tell me how to update fill colour too with text in another sheets

I have an excel sheet where i enter data monthwise horozontally. In a seperate sheet i want to link only latest data entered how to do it

Thank you so much for this amazing video! You explain it so well! I’m going to call you the “Excel Guru”. 😂❤

Chester, thank you very much for the way you explain this, one thing I have a question on is... when I am transferring a column from work book 1(master workbook, the one I enter data on) to workbook 2, like a group of names, I would like the names to stay on workbook 2 even if the name is removed off of workbook 1 and further more If I enter the name in workbook1 the second time say...in about a couple months apart I do not want it to duplicate on workbook 2, I can't seem to figure it out. Oh, I forgot to mention that my workbook 1 is made up of 6 worksheets and some of the data that is entered on the 1st 4 pages of worksheets I have being transferred to pages 5 and 6. I want to pull a couple of columns off of page 6 and be transferred to a new note book which will keep a group of names down a column so that I can total up at the end of a calendar year.

Hi Chester,

Thanks for sharing the tricks & tips in Excel... this was a great help.

i have another issue. My other team is updating data in excel, they mention city name in one column. i want to link that file with my file saved in my o365 account. but i don't want all data, I want data with the specific city to be linked in my excel.
how can i do that? pls help.

THANK YOU SOO MUCH SIR!

After Removing the Dollar, how can I edit that new sheet

Is there a way to update your original table from the a cell in another sheet, if a condition is met? Or do the updates just have to come from the parent table? (For example, let's just say that I don't want my staff to see the table, but I want them to be able to update it from another worksheet that is referenced with your methods. I have a patient entry form (for entering data) that is stored to a table, and I have another sheet ("Update Records") that is used to provide updates or additional notes to the parent information; I can use INDEX MATCH to bring over the data based on a search for the patient name, but how would additional notes be saved to the parent table if entered on the "Update Records" table)

How can new rows be added in the data of original sheet and have it be immediately reflected on the linked sheet? Thank you.

Help, I need to have specific cells on one sheet update from data that will come in from the next cell down on the origin sheet, The users on the origin sheet will enter data in the next cell down each time, the main sheet cells will not change they just need to show the updated data from the next cell down. How would I do that. Thank you for your help

Stich in time saves nine. Jose N.K

I am using the copy and paste link cell reference method. The problem I am having is that when I insert a row in the source data, the linked cells are still referencing the "old" cells. How can I fix this?

Great video .. I have a question, what if my new table is in a different format than the source ? Like let’s say the rows in the source is my columns in my new table , how can I pull the data from there? Thanks

Excellent video! However, what I'm looking for is different. How do I auto highlight a name from a separate sheet when the specific name is chosen from a drop down list?

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

How many sheets of data we can link at a time?

Many years ago I did a project, but I lost it, the disk, password, etc. I just can't remember the steps I used. Here is the scenario example In one sheet: 1 Apple (textbox to click), 2 Pear, 3 Watermelon, 4 Banana, 5 Grapes. My question is when the responder clicks on box to select either answer, I want the number next to the fruit to be placed on another sheet where it will have Q1, Answer on row 1, and so forth. I do remember I used a little VBA codes. So the responders returns the questionnaire, I would have ready calculated behind the scene all the answers. I think I put the 5 boxes in vertical orientation each box on each row and cell. And I told VBA if box on row 2, column c is clicked, then put 1 on the another sheet row 2, column B. I think I named the checkbox as checkbox1. I believe I told VBA if checkbox1 located on column B, row 3, then input 1 on the another sheet. How can I do it or is there another automated way. I could try using google forms, but some companies have aversion to google forms because you have to use goggle drive and share for security phobia.

How to link sheets so data still updates correctly when sorted on main sheet

I combined data from tables from different worksheets by Querry. Data was combined and loaded in to one table.

I added a new row in a table in a sheet. I refreshed the Power Querry. Power Query inserted a whole new combined data table, including data from previously added new row.

The problem is that Power Querry did not delete old combined table >> repeated data.

Does anyone know solution?

How to know if one excel sheet ()has some truck number and another excel sheet has that truck no. or not?

Can you edit a linked workbook table without opening the original linked file

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.

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

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!

Chester, Thankyou for the tutorial. I highlight data I've updated in the source sheet using a different font colour and I need that same font colour to automatically copy through to my linked sheet. How do I do that?

Is there a solution wherein when you save the excel file, the link just disappear and it turns to normal values?

Solve my problem, thanks💕

In practicality.. we will not be able to get to convert the source file to tables all the time..but we will want our data updated in our sheet.. So the source is just excel no table but the destination is table or what ever is fine. .May be a extending this video to cover that aspect would be great sir.. Between great voice and patient explanation

Pls help me regarding this doubt
I have 2 Excel files
First file having 10 customers data
Second file having 15 customers data
But both files have 7 common coustomer
So I want to update only the first file so whatever common customer in the second file will get automatic update
Could you help me regarding this

so helpful

Thanks

Is there any way of linking sheets so that updates made in one of the sub sheets will update the main sheet? Example, someone updates a subsheet with notes, that those notes will go back to the main sheet. So updates can go both directions, not just one direction.

Excellent explanation, thank you!

I've been doing exactly this for a read only live parts stock workbook. I tried CHOOSE & FILTER functions as well but they don't seem to work using a shared cloud based workbook.

Linking only works if both workbooks are open. For example, if I have closed workbook 2 with the monthly plan, but I want to show the plan for the week on the open workbook 1. I select the desired week using the dropdown list in workbook 1. Is there any solution for the above problem? Thanks.

Thanks! So helpful -