Quote Finder

The Quote Finder was designed to handle the tasks of a Language Coordinator at M3. By getting the needed information from an Outlook element and compare the needed services with a Database of vendors, the Language Coordinator was able to filter, sort and select the needed services from the best combination of vendors. The time spent for a quote was hereby decreased from 25 minutes to 1 minute while the margin was increased.

Biggest Challenge: Horizontal sorting of a combination of merged and unmerged cells.
Resolution: Unmerging all cells, assign customised values for each cell in the empty header, sort horizontally, merge cells again and reapply colouring. (see code below)