Master excel spreadsheet
2454
$$
- Posted:
- Proposals: 34
- Remote
- #1654827
- Archived
Business Planner, Excel Guru, Database Professional, UI designer, Content Writer, Research Professional
Prague
A full time freelancer with expertise in various data analytics tool such as MS Excel, Power BI, GDA, etc.
Ahmedabad
17195291199423122805012671401398726160728416497881680481178042817699801772108
Description
Experience Level: Intermediate
I manufacture pet grooming products and want to create a master sheet that list all the relevant line information which can then be manipulated using a drop down menu to choose the pre-selected columns with reference to pricing. So for example if I choose distributor from the menu, only the relevant pre-selected columns will show, or if I choose retailer from the menu, only the retailer prices and corresponding relevant columns will show. This was I can have all my products on one master document and be able to use this to choose which prices I need and then can send off to my customer. Hope this makes sense.
I can create the master document no problem, but don't know how to build in a menu system that automatically chooses selected columns. And maybe there are a few ways of doing this to consider?
The sheet needs to be setup so that it will be easy for me to add more rows as we add to our product range and also easy enough to add the relevant columns to the specific price lists.
The range is currently around 25 products.
Thanks
Mark
I can create the master document no problem, but don't know how to build in a menu system that automatically chooses selected columns. And maybe there are a few ways of doing this to consider?
The sheet needs to be setup so that it will be easy for me to add more rows as we add to our product range and also easy enough to add the relevant columns to the specific price lists.
The range is currently around 25 products.
Thanks
Mark
Mark H.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
14 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Mark,
Are you ok with the development of GUI based application with mysql as backend?
Thanks
Sumit
SaS Technologies -
Hi Mark
Just a thought..
Excels can crash and get corrupted.
Have you considered any web based or stand alone apps for this? 25 is quite a lot of products and using a app will ensure future scalability.
Do let me know of you would consider it.
Best
Ari
468582468534
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies