Sync between data and sheet

[FastCode]

Dear
Im trying to automatically update a table from sheet to another and each has a common ID, so when new row added to the data automatically it will appear to second sheet .Also the old records will be updated if there is any changes happening. I attached my file and explained inside. Can both file sync together? Do i need to put formula all the way down .
File

 

[ravi2628]

Dear
Im trying to automatically update a table from sheet to another and each has a common ID, so when new row added to the data automatically it will appear to second sheet .Also the old records will be updated if there is any changes happening. I attached my file and explained inside. Can both file sync together? Do i need to put formula all the way down .
File

Hi Fast code,

Gofile - Free Unlimited File Sharing and Storage

Gofile is a free, secure file sharing and storage platform. With unlimited bandwidth and storage, you can easily store and share files of any type without any limits. Our advanced features, such as CDN support and password protection, make Gofile the ideal choice for individuals and businesses...

gofile.io

I have done the Changes in the file please check is that the logic you are looking at.

attached link for your reference. just add the data in your sheet and click refresh

 

[FastCode]

Hi ravi2628
Thank you so much ..Can you explain how you did this ? Appreciate your help

 

[ravi2628]

Hi ravi2628
Thank you so much ..Can you explain how you did this ? Appreciate your help

using PowerQuery of the Table

Step-1(Select Data Tab and click on from Table/Range)

Step-2(automatically opens in PowerQuery Editor)

Step-3(Apply filter on the required Field(Used/new) as new

Step-4(Cliclk on Home tab Close and Load to)

Step-5(Select the Existing Work Sheet and from Cell where it has to be started)

if any new data is added just click refresh from data tab.

Regards,
Ravi

 

[FastCode]

Thank you so much very clear .one question what if I need to add extra columns on the new table without effecting the data sync

 

[ravi2628]

Thank you so much very clear .one question what if I need to add extra columns on the new table without effecting the data sync

if it is formula no problem you can add

sample shared for your reference.

Gofile - Free Unlimited File Sharing and Storage

Gofile is a free, secure file sharing and storage platform. With unlimited bandwidth and storage, you can easily store and share files of any type without any limits. Our advanced features, such as CDN support and password protection, make Gofile the ideal choice for individuals and businesses...

gofile.io

Please mark as a solution if Query is solved