Forum Discussion
Adding new rows from source sheet to linked sheet
You should use Power Query.
Select the first table and under the data tab, in the "get and transform data" area, select "from table/range". This will load PQ where you can format if you'd like. Select close and load drop down, then close and load to-then choose only create connection. Do the same for the other table. Then you need to go back to PQ, to do so, select get data, then launch PQ editor. Select table1, and choose Append Queries drop down, then select append queries as new. In the box that pops up, table1 will be selected for you, you have to choose table2 in the bottom half of the screen, then hit ok. Your mergered table will appear, and now you'll select the close and load drop down arrow, and choose close and load to Table.
When you want new data to show up in the new table, refresh all and it'll show up.
You should use Power Query.
Select the first table and under the data tab, in the "get and transform data" area, select "from table/range". This will load PQ where you can format if you'd like. Select close and load drop down, then close and load to-then choose only create connection. Do the same for the other table. Then you need to go back to PQ, to do so, select get data, then launch PQ editor. Select table1, and choose Append Queries drop down, then select append queries as new. In the box that pops up, table1 will be selected for you, you have to choose table2 in the bottom half of the screen, then hit ok. Your mergered table will appear, and now you'll select the close and load drop down arrow, and choose close and load to Table.
When you want new data to show up in the new table, refresh all and it'll show up.
