Project Description

European Size List Distribution

The Challenge

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.

The Solution

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.

The Results

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.

Mairi Scholes, Director Marketing Operations, Adidas Group

Speak to our Manchester based team

Provide your details for a call with one of our Excel experts.

Are you ready to make Excel work harder for you?