Completed

Design of Excel Dashboard to increase ease of Use

Published on the July 04, 2020 in IT & Programming

About this project

Open

Hi freelancer,

What I am looking for is someone who is a master in excel and knows how to the create efficiencies by combining different sheets to provide a sole output.

In short, this is the situation and how I would like to automate it. Every week I receive a groceries list from 6-7 different suppliers with the same items. The main issue is that all the suppliers have a different way of describing these items, even though these items are the same.
I've attached some files where you can see what my issue is.

The solution that I'm looking for is where I can upload the groceries sheets, ( maybe per each tab), where these is automatically converted to uniform grocery list where I can use the match and index function to see the best priced item per supplier.

Thanks for your time,

Chris

Category IT & Programming
Subcategory Desktop apps
What is the scope of the project? Small change or bug
Is this a project or a position? Project
I currently have I have specifications
Required availability As needed
Required platforms Windows

Delivery term: July 31, 2020

Skills needed

Data Structures Database Microsoft Excel Big Data

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!

Other projects posted by C. B.