European Size List Distribution
Adidas came to us looking for a solution to an outdated product distribution system, which was having a noticeable impact on overall workbook accuracy, as well as efficiency due to sheer size.
A solution was needed that would better manage product distribution across various European locations, which also had to include the capacity to handle multiple variables such as product sizes, styles etc.
Once understanding the scope of the challenge at hand, the Bespoke team discussed and reviewed the most effective course of action, which was to rebuild the Adidas European size distribution system.
This would use VBA to optimise outdated workbooks, thus having a noticeable impact on the current spreadsheet setup. One of the main challenges being faced was using multiple workbooks to make business decisions, and thus was impacting actions overall.
Since implementing the optimised tool, Adidas have seen staggering outcomes resulting from our strong relationship; including;
Massively improved overall efficiency and time savings related to workbook management, thus increasing time actually benefiting from available data, rather than admin.
- Reduced the size of the workbooks by almost 70%, thus improving communication across the board.
- All errors were eliminated, with tailored error handling allowing users to see when invalid items were selected.
The team at Bespoke Excel were amazing in providing us with a solution for our business that worked locally and across Europe. The result was a format which is still being used today, I can’t thank them enough for all their hard work.
Speak to our Manchester based team
Provide your details for a call with one of our Excel experts.