Build Excel Table for Data Entry with Searchable Combo Boxes/Validation
- or -
Post a project like this2366
$$$
- Posted:
- Proposals: 27
- Remote
- #1750927
- Awarded
✌️#1 SEO Expert |Digital Marketing Specialist| Web Development | Social Media Specialist| WordPress| Wix | Squarespace
Secaucus
20 plus years of exposure of assisting its clients in Financial Modelling, Company valuations for Fund Raising in various stages of FR life cycle.
New Delhi
Data Analyst, Database Administrator, Excel Expert, Dashboards, Access, Database Design
Leeds
Business Plan, Pitch Deck, Financial Forecasting, Equity Research, Excel Modelling
Dubai
Data entry, MS Excel & Word Work, PDF Conversion, Book Keeping, Virtual Assistant & Customer Service
New Delhi
c/c++ Progrmmer, auto cad designer, photoshop designing, word to PDF, PDF to word, PDF editing, Microsoft office,data entry.
Pathankot
91723913201301314007133089114494731648805180240118255271837357188060018795951871363
Description
Experience Level: Expert
Estimated project duration: 1 day or less
General information for the business: Personal Use -- Daily Macro Estimation
Description of excel work: Develop a worksheet that allows me to type in foods in Column A and Columns B-E lookup corresponding nutrient values that reside in a separate tab.
Sheet 1: "Daily Food Consumption"
Column A: Google-like searchable combo boxes tied to the 'Master FoodList' table; appears in each data validation cell when you double click. Selected values populate corresponding cell in Column A. Up to 30 rows available for data entry.
Columns B-E: Index/Match formulas that lookup values in the 'Master FoodList' tab based on the food type selected in Column A
Sheet 2: 'Master FoodList'
Format as a table so that I can add rows for new foods; need new rows to be automatically included in 'existing' validations.
Extra notes:
Description of excel work: Develop a worksheet that allows me to type in foods in Column A and Columns B-E lookup corresponding nutrient values that reside in a separate tab.
Sheet 1: "Daily Food Consumption"
Column A: Google-like searchable combo boxes tied to the 'Master FoodList' table; appears in each data validation cell when you double click. Selected values populate corresponding cell in Column A. Up to 30 rows available for data entry.
Columns B-E: Index/Match formulas that lookup values in the 'Master FoodList' tab based on the food type selected in Column A
Sheet 2: 'Master FoodList'
Format as a table so that I can add rows for new foods; need new rows to be automatically included in 'existing' validations.
Extra notes:
Heather M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
4 Nov 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Heather
Can you share sample and is this for desktop or cloud? -
Good Morning Heather,
Do you have an existing spreadsheet that contains the initial data that you wish to use? If you do have this information would you be kind enough to attach it to your reply.
All of what you ask is achievable. What version of Excel / Operating system will you be using?
Regards
Tony H
522194522036
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