I work in the procurement department a hotel. Every week approximately 7 different suppliers send price list spreadsheets outlining this week's price for their F&B Products. I then have to input the price of each item the supplier is offering into one master sheet (Weekly Produce 2014) that compares the prices of each supplier's items so that our hotel group buys from the lowest supplier. This sheet is then passed on to the different managers in the chain so they can purchase from the lowest supplier. The item list from each supplier is essentially the same.
Is there a way that this process can be automated? As you can imagine, it is very time consuming and tedious to input the prices of each item offered in the master sheet for the different suppliers.
Bookmarks