Microsoft excel autocomplete list
- or -
Post a project like this3182
$$
- Posted:
- Proposals: 11
- Remote
- #828356
- Awarded
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
WordPress DataEntry | uploading | Web Admin | Photoshop | Data Entry | PDF2Word | Virtual Assistant | Ad-posting
Zongzhai
Excel and Access Analyst/Developer, Tableau, Reporting, Office Automation, Taking Complex Problems and making them simple
Reading
957453549572561516719567374652992730505818422897644963451989063
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: creating a warranty file with access to product list
Kind of development: Customization of existing program
Num. of modules: 1
Description of every module: create a warranty file for past 5 years, and ongoing years - we want a dropdown list option form a separate tab with a product list and when you start typing in the product code it should jump to that section in the excel list.
Description of requirements/functionality: I currently have an excel file with a tab which has a 'warranty file' for each separate 'year' (2010-2015) and all our information is paper based currently, we want out administrator to input this data onto the warranty file however we created a list of products in a different tab and applied a dropdown list menu using data validation, the problem is, there is no autocomplete on the list, so the only option is to type in the correct product code in full, or run down the 'list' using the scroll button, neither is a good option for us. We want to be able to start typing in a part number and the options should come up in the list view.
I also want the same for 'customer' and again use a separate unique list to choose from with autocomplete activated.
Moving forward, we want to start using this as a day-to-day data entry system for all warranties so it is no longer paper based.
Solution must be reproducible for new years.
Warranty file is held to account for 5 year product warranty we offer people, we need to to be able to search to check warranties are valid.
Specific technologies required: Must be using Microsoft excel
OS requirements: Windows
Extra notes: If you are able to offer excel support on this, we have plenty of other 'jobs' which we could use your services as excel is highly used in our business
Kind of development: Customization of existing program
Num. of modules: 1
Description of every module: create a warranty file for past 5 years, and ongoing years - we want a dropdown list option form a separate tab with a product list and when you start typing in the product code it should jump to that section in the excel list.
Description of requirements/functionality: I currently have an excel file with a tab which has a 'warranty file' for each separate 'year' (2010-2015) and all our information is paper based currently, we want out administrator to input this data onto the warranty file however we created a list of products in a different tab and applied a dropdown list menu using data validation, the problem is, there is no autocomplete on the list, so the only option is to type in the correct product code in full, or run down the 'list' using the scroll button, neither is a good option for us. We want to be able to start typing in a part number and the options should come up in the list view.
I also want the same for 'customer' and again use a separate unique list to choose from with autocomplete activated.
Moving forward, we want to start using this as a day-to-day data entry system for all warranties so it is no longer paper based.
Solution must be reproducible for new years.
Warranty file is held to account for 5 year product warranty we offer people, we need to to be able to search to check warranties are valid.
Specific technologies required: Must be using Microsoft excel
OS requirements: Windows
Extra notes: If you are able to offer excel support on this, we have plenty of other 'jobs' which we could use your services as excel is highly used in our business
STEVE R.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
40%
Last project
14 Jul 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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