Hello everyone,
I was trying to use VBA to update a Table ("db_Joined", set in the "DB_Joined" Sheet), which is the result of two tables ("db_Analyzed" and "db_ToBeAnalyzed, set in their respective Sheets) joined with a Power Query.
Since the Joined Table generates some pivot tables, which are copied into a Dashboard, I would like to be able to update everything automatically, whenever I add a new row to "db_Analyzed".
Obviously I tried many times to do this. I can do it with a simple table, but it looks like I'm doing something wrong in this particular case...
Do you think it is a good idea? If so, may you help me? I'm open to any advice!
As always, I attached my example workbook. It is zipped, because normally it occupies 1,02 MB.
Thank you in advance!
ifritaeon61
Bookmarks