So I have around 20 worksheets with the same columns (They are product reference lists for different country's ) I have made use of power query to merge them all together to one big one where I can filter whatever I need to look for and see what countries have that reference. The problem is when I need to either add a new product or eliminate a product from all of the countries or sometimes just some. I would like to know if thereīs a way I can do this from the master table as right now if I add a new row or eliminate one when i press refresh it will go back to how it was before as I havenīt deleted/added the row from every individual worksheet.
Thanks.
Bookmarks