Auto Expanding Drop-down List?

May 6, 2014

I have a list (C5:C16) and I want people to be able to add more names to the bottom and it add to a dropdown list on another page.

View 6 Replies


ADVERTISEMENT

Drop Down List Auto

Nov 3, 2008

I have Excel 2003 installed on the companies computers. Many people use an Excel file and I am trying to make their work easier. There is on command which has a dropdown list made by me. What I would like to find out is that is there any possibility to make Excel help the user to choose from the drop-down list (the list is quite big). Is it possible to select a cell in this column and type in the cell and then Excel help the user. I mean (this list contains country names in abc order) if the user types S and W then Excel auto-corrects it to SWEDEN. Can this be done with Excel 2003?

View 2 Replies View Related

Auto Sort Drop-down List

Jun 14, 2009

Is it possible to autosort a drop-down list based on the number of times an item is selected? A drop-down might have 500 lines so it is user-friendly if the top lines are those selected by users the most often.

View 4 Replies View Related

Auto Fill In- Way To Take A Drop Down List

Nov 8, 2009

is there a way to take a drop down list and pick 1 then have excel fill in the info i seven cell example if list box is 3 then cell 1-7 = 1 and is list box is 1 cell 1=1 cell 2-0 cell 3 = 0 cell 4-7 = 1

View 9 Replies View Related

Auto Complete With Drop Down List

Feb 21, 2008

I have developed a spreadsheet that allows a user to "Autocomplete" a name by doubleclicking on a cell and typing in a few letters of the person's name.

I named the range that I want to appear in my list and I created the combobox in sheet 1, not in a userform. My problem is that when I doubleclick on a blue cell in Sheet 1 and type in a few letters of the person's name, the name doesn't fill into the cell. I have already specified a ListFillRange, so the Combobox knows what I am looking for. For some reason, the drop-down list is hard coded and won't populate the name that the combobox has already found. I don't receive any errors from the code that is already in place. If you could help me figure you how to get the names to populate in the blue cells, I would greatly appreciate it.

Attached is an example. If you try doubleclicking and typing in, say "Doe, John" in one of the blue cells in Sheet 1, you will see his name, but when you hit enter it won't populate. The cell stays blank!

View 3 Replies View Related

Auto Sort Values In Drop Down List

Dec 12, 2009

i had a list based on dynamic formula.When ever i update(Add or Delete) New items to my List the drop down list should also be updated and sorted in Alphabetical order(Ascending :Words Starting with A - Z). How do i remove the blanks in the drop down list whenever i delete the data in the Source Data.

View 3 Replies View Related

Auto Date Stamp With Drop Down List?

Feb 18, 2009

I'm producing a new spreadsheet to track issues and thier completion. I've used the code I have on another spreadsheet, that I got off this site, thanks. What I would like to change are the following:

1) The status column (F) uses a drop down list, located in cells Z1 to Z5.
When an option is selected, the date updates in column G automatically.
What I would like is for the date to only update in column G if the drop
down list is changed to Completed.

2) If the status is changed to completed by mistake, and then changed back
I would like the date to disappear.

Finally, can I make the date columns jump automatically so the person entering the data goes from column F to column H.

View 3 Replies View Related

Drop List Value Auto Copy To Another Sheet

Jan 3, 2013

I have A dropdown list (form control combo box) ...in that the values are jan,feb,mar,apr... property of cell link is given as C4..... now my doubt is suppose if i select mar from drop down, in sheet the cell C4 should Show Mar only.....

View 6 Replies View Related

Drop-Down List With Auto Complete As You Type

Aug 12, 2009

I have a large list of data records, 600+, and would like to use List Validation but find EXCEL's default Validation not appropriate for such long lists. What would be perfect is similar to what you get in Access, when you type in part of the record string required, a drop-down list appears and shows you the record entries that have that string within them and not necessarily in character order, quickly wittling down to the few records that apply and then use your arrow keys to move and select the correct record, etc. Example, I own a salon, and many shampoo ranges have many similar products:

Superstar
Superstar Blow Dry Lotion
Superstar Leave In Conditioner
Superstar Shampoo
Superstar Conditioner...........

View 5 Replies View Related

Auto Fill Cells Depending On Drop Down List Selection

Sep 22, 2008

I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.

This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)

I have made drop down lists to select each of the values for the three conditions and want to show the total for them

i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.

i.e. i am away for 6 days i get 15 extra, if i am in Europe i get another 50 and if i work 12 hours i get 30.

I want to be able to calculate this total in each cell for that day.

I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.

View 12 Replies View Related

Auto Expanding Combo Box

Jun 9, 2007

I have a script that converts any List based Data Validation cell into a combo box when you click on it...What I am trying to do now is find a bit of code that will auto expand the combo box.

View 3 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Combobox ListFillRange For Expanding/Shrinking List

Apr 2, 2008

I'm using a Combo Box the contents of which are on another worksheet.

This data is pulled in using a database query(MSQuery). The data source could be 5 lines long or thousands of lines long(Customer dependant).

I have tried specifying the listfillrange using $G5:$H8700 for example which works for the current dataset. If i change the dataset which only has range G5:H87 then the properties of the combobox listfillrange change to $G5:$H87 but the actual list has more than 82 lines and displays the 82 lines over and over again. I haven't counted the number of lines but it could be thousands.

View 8 Replies View Related

Drop Down List Values Dependant On Value Of Another Drop Down List

Dec 9, 2009

I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.

If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.

View 12 Replies View Related

Excel 2003 :: Expanding List To Use In Mail Merge Program To Produce Tags For Direct Mailing

Sep 25, 2012

I have an Excel 2003 list with four columns as shown below:

Zipcode
CRRT
Count
Bundles

85710
C004
693
14

85710
C005
867
18

85710
C006
1021
21

I want to "expand" this list to use in a Mail Merge program to produce tags for our direct mailing. Each bundle contains 50 letters, so in the first line on the above spreadsheet, there will be 13 bundles of 50 and 1 of 43. Currently, I can cut and paste to create the following table, but there has to be an easier way...

Zipcode
CRRT
Count
bcount
Bundle
ibundle

85710
C004
693
50
1
14

[Code] ........

So as I pull this into a mail merge I will get a tag that shows the zipcode, the crrt, the total pieces for that crrt, then number of the bundle for example " 1 of 14" and the quantity in that bundle, for example "50 of 693", then the next bundle tag will print, 3 to a page. I know that here has to be an easier way either in the mail merging process itself or with EXCEL? Am even open to build these with ACCESS to create the tags. The beginning database contains anywhere from 350 to 800 lines of original data, so as you can see the cut and paste is VERY time consuming.

View 6 Replies View Related

Creating Dynamic List Of Data From Expanding Table Of Data?

Feb 13, 2013

I need to create a dynamic list from a table of data.

I have performance data for 110 different pumps. Data points are generated every hour, and the table is updated with new data periodically. I want to automate the population of a list of 6 different pumps, and specify the date range populated. To put it another way: I want to place data from Pumps 1 through 6 for all of November into Columns A through F. Then I want to clear that data, and show data for Pumps 105-110 for last week in those same Columns.

One of the main goals of doing this -- other than quickly narrowing a field of data -- is being able to quickly chart this data on a scatter plot with a custom format. The pumps are grouped together by region, and individual pumps have specific purposes. So I need to quickly generate graphs with a series' color scheme or formatting that is consistent and logical between different pumping regions.

I haven't been able to make pivot table work because of the graphing issue, and also because of the way it handles data points and presents data. I would like to make this work with excel functions and maybe some filtering, but I'm not opposed to figuring out a VB script if you think that's what I should use.

View 1 Replies View Related

Auto Fill With One Of Two Drop Down Lists...?

Jan 2, 2010

I am trying to do this in several cells/several ways, looking for the generic formula, here is one example:

If User selects "Expenses" in
'Activity' B3
from drop down list of "Expenses" or "Income".

I want C3 to populate with drop down list - the words to choose from are listed in 'Expenses' B1:AI1

If User selects "income" in
'Activity' B3
from drop down list of "Expenses" or "Income".

I want C3 to populate with drop down list - the words to choose from are listed in 'Income' B3:AI3

View 5 Replies View Related

Auto Complete Information From A Drop Down Box

Mar 27, 2007

I want to use a drop down box to pick a name and then when that name is entered to automatically fill information such as email address, phone number, address into a spreadsheet similar to auto complete that are on many web sites when you purchase from them often.

View 2 Replies View Related

Created Validation Drop-down List - Can I Make The Row Now Change To The Colour That Relates To The Selection From The List

Jan 13, 2009

I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.

For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange

etc.

Is this possible within Excel 2003?

View 9 Replies View Related

Creating Drop-down Menu: Using Auto Complete

Dec 6, 2006

I have created a list in a Microsoft Excel Workbook (names and corresponding numbers) and named the list.

Then, I created a drop-down menu through Data/Validate/List that included the names.

I can look the names up in the drop-down box, but I would like to be able to type a few letters and Excel auto complete the rest of the name. For instance I would type Ja...and James Doe would come up with the mes Doe in black (highlighted).

Is there a way to do this in Excel?

View 9 Replies View Related

Auto-complete Feature Cell Drop Down

Jun 1, 2007

I found this code for an auto-complete function from this website: [url]
It works well, but see the web example before using it. You have to name a range MyList with your potential values for it to work.

Currently, you have to click the drop-down arrows to see the potential entries. I want to make it so that after the user enters the first 3 characters it will automatically "drop-down" and show the potential entries. This will save a trip to the mouse and let the user see whether their entry is in the system.

Option Explicit

Dim i As Long

Sub KeyEventOn()
For i = 65 To 90
Application.OnKey "{" & i & "}", "'MyValidation """ & i & """'"
Next
End Sub

View 4 Replies View Related

Auto Fill Based On Drop-down Choice

Dec 13, 2007

I'm working on a workbook that already exists and that contains multiple worksheets (A,B,C,D,...), each with specific info (each row consists of an item name (item 1, item 2, item3,...)and all characteristics of this item).

We now want to add a help page for each worksheet :
A => A help
B => B help
...

So for each item (=row) in sheet A, there should also be an according row with additional info in A help

First, I used static hyperlinks to switch from the item in A to the corresponding help in A help. However the item list can be extended in the future (meaning rows inserted) and this will cause these links to fail. Therefore I switched to dynamic hyperlinks by inserting names (in stead of the original cell names) for each item in both A and A help. This involves a lot of work since you have to give all the involved cells a unique name and you have to refer to this unique name when you set up the hyperlink.

View 2 Replies View Related

Drop-Down List: Generate A List Based On The Value Of A Cell

Jan 7, 2009

I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.

View 3 Replies View Related

Drop Down List Defaults To Middle Of List

Sep 3, 2009

why my drop down list defaults to the middle of the list when first clicking on the arrow that opens the list? I created an alphabetical list of all US airports but when I open the list, it starts at "D" instead of "A" which is the top of the list.

View 5 Replies View Related

Auto Populate Data Values Based On Dependence Of Two Drop-down Lists?

Feb 1, 2013

I am trying to create an easy fill spreadsheet for a game. I am looking to have data values auto fill based off of the entry of 2 prior drop down menus.

I would like to have values for "Move", "Str", "Spd", "Skill", "Armor", and "Value" auto populate after the "Race" and "Role" has been selected. Data for these auto fills I have put on Sheet2 while the main file itself is on Sheet1.

If possible I would like to have Value increase by 5 for every level in "Rank" on the sheet.

View 1 Replies View Related

Create A Sub List From A Drop Down List

Jan 26, 2009

I need to create a 'sub' list from a drop down list.

I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.

And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.

View 9 Replies View Related

Drop Down/ List Box

May 22, 2008

i have a spreadsheet with several fields. i want to derive information from this data. i want to be able to control the output through the use of list/drop down boxes.

so the user will choose several criteria AND based on this criteria, the ouutput will reflect user requirements.

View 12 Replies View Related

Drop Down List Using VBA

Dec 1, 2007

I have a workbook with around 35+ sheets on it and I was wondering if its possible if I could put these sheets in a drop down list in say cell A1 so it would be easier to navigate the sheets. Is this possible with out using VBA code if so how would I go about doing it?

View 9 Replies View Related

Add To A Drop Down List

Jan 13, 2010

I have a drop down list of shipping Companies. If the name of the company is not in the drop down list how do I allow the user to type in the name then have it save in the drop down list source?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved