Using Copilot to compare 2 different Excel price lists and update one with latest prices

Question

Dear all,

we are selling broadcast products and have many pricelists from suppliers. They are frequently updated either with new prices or products. Now we have to manually edit all our Excel sheets to later import them as csv. files into Pro Alpha 2.0, which is not only extremely time consuming but also prone to make mistakes.

And we are talking about 1000´s of articles and not just 10 like shown in many demos.

Is there an intelligent and efficient way to use Copilot to compare 2 work sheets, point out the differences and update one with the other.

Thanks,

Best regards,

Mark

Answer 1

Hello Mark Stefenelli ,

Thanks for reaching out in the Microsoft Q&A!

Copilot isn't directly designed for working with Excel files.

For Excel users, leveraging VBA can streamline your workflow. These mini-programs can compare lists, highlight price changes, and update your existing list.

If you're open to a more advanced solution, consider using Python with the Openpyxl library.

Both approaches will save you significant time and ensure your pricing remains accurate. Choose the method that best suits your needs.

Useful Links:

https://learn.microsoft.com/en-us/office/vba/api/overview/excel

https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.excel.html

If you find this helpful, please accept this answer to close the thread. Thanks!!