Forum Discussion
Connect one sheet to another
Hello Community! I would like to make one sheet connected to another sheet. IF I delete data in Sheet 1 and paste new data into this, I want Sheet 2 to bring through only data with those headings...
Hi,
I propose to use Power Query for this. Import the data from sheet 1 into Power Query (Data | Get data from Table/Range), then delete in Power Query the columns that are not needed and load the results in sheet 2.
Once you have changed data in sheet 1, do a refresh (Data | Refresh All) and you will see the updates in sheet 2.
Kind regards,
Martin
I propose to use Power Query for this. Import the data from sheet 1 into Power Query (Data | Get data from Table/Range), then delete in Power Query the columns that are not needed and load the results in sheet 2.
Once you have changed data in sheet 1, do a refresh (Data | Refresh All) and you will see the updates in sheet 2.
Kind regards,
Martin