Forum Discussion
Power query: how to add (manual) data that doesn't disappear when refreshing.
I am trying to use powerquery to make a holiday planner for our team, but I encountered some problems. The idea is that we can add new/remove colleagues in a team members table, refresh the query and...
MeikeR I did a little more on this, although I'm a bit hampered by not really understanding where you want to go with this. Anyway, I basically just converted everything into queries to get what I thought you were after.
The Members and Days tabs are used to generate the Data Entry tab using "append". Put the data for the individual days here. Gen2 is just a query containing the Data Entry information and is only included to better show how this concept is working. Present is just the Members table manually copied with some rows deleted from the middle. Final is the merged query of Gen2 and Present, using a merge including all of Present and matching from Gen2.