The Reckitt Benckiser Group plc is a multi-national consumer goods company, headquartered in Slough. It is a producer of health, hygiene and home products.
Reckitt Benckiser approached Bespoke Excel with a unique challenge. The business had an existing process where there was a large amount of manual work involved in naming and renaming files and folders. Due to the sheer number of files being renamed (circa 1,500), this was causing a strain on operations time, as well as being susceptible to human error.
There was additional complexity in terms of where the files are stored, as well as ensuring that folders are not duplicated, deleted or moved elsewhere.
By designing and developing a bespoke VBA based tool, we were able to devise a solution that would take over the drawn out, manual process of consolidating a large number of files. The macro massively increased efficiency overall, as well as took over the task of processing, naming and writing 1500 files to decentralised folders.