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... [url removed, login to view] I need to be able so see the work done / formula / etc and be able to copy and paste into additional documents.
23 freelancers are bidding on average $26 for this job
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
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
Hi, I can deliver the completed project within a day. Relevant Skills and Experience I have more than eight year experience in production and distribution accounting. Proposed Milestones $25 USD - Full project