Forum Discussion
hasanhasan
Feb 17, 2021Copper Contributor
Update a price list automatically
Hi everyone, Is there a way to update a price list (updating values for existing products and adding new products and their values if they are not existed in the table) using power query? For exam...
mathetes
Feb 17, 2021Gold Contributor
I'll let someone else handle the Power Query option (not available on my Excel for Mac), but if you could post a copy of your spreadsheets and that source file you refer to, I also think it might be possible without needing Power Query, depending on how you've organized your existing database.
Please don't post an image; the actual sheet(s), just making sure any confidential or proprietary information is rendered anonymous. And seeing your actual data layout would no doubt be helpful to anyone addressing the Power Query side of this as well.