Excel append querry update

[ndmalam]

An Append Querry is created using two seperate tables in a workbook.
Table1+Table2= Append1
Now if i make changes or add more data in Table1 or Table2, Will the Apoend1 Query update it self with new Data?.
Secondly if i add data in Append1, will it be visible in tables?
I am usins Ms exell 2016.
Also help me, where to add new data to keep all files update.
Best regards

 

[GraH]

Now if i make changes or add more data in Table1 or Table2, Will the Apoend1 Query update it self with new Data?.

The append query is the result of T1 + T2. Adding data to either T1 or T2 will result in an updated append query after hitting refresh.

Secondly if i add data in Append1, will it be visible in tables?

Since the Q1/Q2 on T1/T2 do not refer to the result query, how could this be?

Note you can add data directly to the append data and keep it in the append query, but that's a little bit more advanced and requires you to write some M-code manually. Going by your question, you still are in the early stages of learning Power Query. I do not advice to jump to this level. Follow the set path of UI only before tweaking M before writing custom M.