Ready to chat data? That's what we're here for
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.
“The Bespoke Excel company is certainly very effective with gathering and understanding end user requirements and quickly turning requirements into a solution. They were able to come up with bespoke and user friendly excel solution. We run a cost centre reporting process that processes up to 1500 files and needed a VBA macro to consolidate the files and to write them out to decentralised folder locations. Throughout the entire process of design and test Bespoke had been very supportive. Pleased to be able to recommend them as an Excel solution expert company.”
Elize Rushton
