I am creating an inventory excel document. There are a number of columns that will have data entered into them. date - location - DESCRIPTION - SHELF. The two columns that are of importance (i am having issues with) are the DESCRIPTION and SHELF. When the user enters a DESCRIPTION ( a specific description) it will automatically fill in the shelf.
I already have a solution for the that function using sheet two. HERE IS THE PROBLEM...
I Need a searchable Drop down list in my DESCRIPTION cell. Drop down list will be a list created from sheet 2 (same file). The list is currently SHEET 2 - A2:A51. I want the user to begin to type a letter(s) in the DESCRIPTION cell and the drop down choices will get fewer and fewer the more the user types. will send a sample file. I want the drop down to show when the cell is live. So, as soon as the cell is entered a drop down will show with 50 choices and as the user types a letter or 2 or 3, the list will get smaller
**** this you tube video appears to be what i am looking for but i don't have the time to do it and troubleshoot it... [login to view URL] I need to be able so see the work done / formula / etc and be able to copy and paste into additional documents.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews.
Best regards
Habilidades y experiencia relevante
VBA/Formulas
Htos propuestos
$25 USD - final delivery
I can set up 2 helper columns to achieve searchability in DropDown box. The formula and process can be repeated when there are similar requirements in future.
Relevant Skills and Experience
18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 15 MONTHS , spent at least 250 HOURS on automation in Excel every month.
Proposed Milestones
$20 USD - Searchable DropDown Box
Dear client,
I have made searchable dropdown in the past for another client in the past. I can show you sample if you want. Please contact me for further details.
Thanks
Roy
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google
Relevant Skills and Experience
Excel
Proposed Milestones
$35 USD - j
Hey There,
Thanks for posting the project. Its looks feasible and am Interested to do it.
I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality.
Next steps:
Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output.
Lets discuss more online on chat.
Thanks,
Aman
Hi,
I am CPA by qualification, having experience of more than 6 years in a reputed MNC as a Financial Analyst, having good knowledge in Accounting and well versed with various Accounting software.
Regards
Pooja shah
Hello,
I am Luis from Venezuela and it will be my pleasure to help you with this project.
I can meet your excel requirements so please contact me by chat and then we could discuss better your project!
Kind regards,
Luis Romero
Hi there!
Your project seems interesting to us and we believe we would be a perfect match for your requirement.
Thank you!
Relevant Skills and Experience
excel
Proposed Milestones
$25 USD - on completion of project
Dear Sir,
I m EXCEL professional having hands on expertise developing spreadsheets I will do your project by developing Drop Down menu which will be linked via V-lookup as you select all data appears.
Relevant Skills and Experience
excel
Proposed Milestones
$30 USD - excel
Hi Dear,
I have understood the problem and can help you achieve the required feature in your excel spread sheet. I hope to hear from you.
Relevant Skills and Experience
I am a PhD researcher with 15 years of experience with excel and can solve the problem. Thankyou.
Proposed Milestones
$30 USD - Drop down menu
hi, I'm Jeneva. I am really interested in your project. According to my experience and skills, I avail to do this job within the time frame. Please inbox me for discuss more details. Thanks, Jeneva
Relevant Skills and Experience
I have skills in HTML, CSS, JavaScript, Photoshop and Illustrator. I have experience in Data Entry in Excel. Data Scraper and SEO. I have plan to implement this job by using excel program.
Proposed Milestones
$30 USD - Complete the project
hi, after entering the data what needs the data format xls or csv file?