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 Repliesi 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 RelatedI 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 RelatedI 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 View Relatedis 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 RelatedI 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!
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.
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 RelatedI 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...........
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.
Is there a way in Excel to have a list of names with values automatically re-sort whenever any of the values change.
The default sort I have in mind is ascending by values.
eg.
CITY VALUE
Sydney 100
Boston 200
London 300
Moscow 400
Houston 500
The values change to:
Sydney 5000
Boston 250
London 8000
Moscow 300
Houston 50
I now want Houston 1st, Boston 2nd etc - automatically - without me having to do a sort again by Value.
Is there a way in Excel to have a list of names with values automatically re-sort whenever any of the values change.
The default sort I have in mind is ascending by values.
E.g.
CITY VALUE
Sydney 100
Boston 200
London 300
Moscow 400
Houston 500
The values change to:
Sydney 5000
Boston 250
London 8000
Moscow 300
Houston 50
I now want Houston 1st, Boston 2nd etc - automatically - without me having to do a sort again by Value.
I have a fairly large watch collection as below which I wear on a daily rotating basis(!).
FORTIS
Seiko
OMEGA SPEEDMASTER
Seiko
SINN 144
Seiko
Accurist
Seiko
TEMPTION
Seiko
OMEGA TRIPLE DATE
Seiko
Junkers....................
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 RelatedI 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 RelatedI 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.
I have dates values in 3 columns.
A1 - Header - "Holidays in XXXX'
B1 - Header - "Holidays in YYYY'
C1 - Header - "Leaves by YOU"
A2:B11 have static dates consisting of 10 dates in each column.
C2:C11 - the user may enter any date at any point of time.
I would like to auto-merge the dates in all the 3 columns (A2:C11) in a single column say D2:D31 and then the system should auto-sort the column based on dates in any one order. So as soon as the user enters a value in say cell C2, all the 10+10+1 dates should get sorted.
Also the constraint here is a user may not apply all 10 leaves at in a year. So many of the cells may have blank values.
How can I sort an array of data based on the selection from a drop-down menu? And can it be 'secondary' sorted with the result from a second drop-down (ascending or descending is unimportant)?
View 2 Replies View RelatedI 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
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 RelatedI 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?
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?
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
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.
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.
Is there a way to have a drop down or some sort of input cell that would change the look and format of the entire worksheet? Not sure how to pose the question?? For example.
What I'm working on is a departmental forecast sheet.
I want my department heads to be able to all look at the same excel file, then be able to input or select their department from a drop down. Once the department is selected that would call for excel to bring up the forecast for their specific department (**Each departments sheet is a little different).
There are only 3 columns, A, B, C and only 10 rows but I would like it to sort automaticaly. I enter data on other sheets and it is loaded automaticaly back to sheet 1 after some calculations are made. I would like the data on sheet 1 to sort automaticaly on column C keeping the rows of data intact.
View 14 Replies View RelatedI am trying to figure out how to auto sort information on a spreadsheet so that when update notes are added by date at the bottom of the list, they are automatically sorted (moved) to the top of the list so the latest update is shown first. I am pretty clueless when it comes to macros although I have given it some attempts after reading other posts without success. I am including a copy of the spreadsheet. The info that I need sorted starts at B43:E43 and goes to B104:E104. That same sort info would then be used for the similar info to the right of this one. For example everything on the line B43:E43 would move together.
View 11 Replies View RelatedFor some reason I have a worksheet that won't sort stuff by Autofilter any more. I built it as a customer database but for some reason today I just can't get the names to ascend or descend. there is something simple I can check for, I can post an empety sheet if needed but right now I can't really post a list of all my customers info.
View 5 Replies View RelatedIs it possible for a column of "sums" to auto sort from largest to smallest? I have a dashboard with 20 charts and I want them to show in the order of largest to smallest but its rolling data so it changes daily.
View 6 Replies View Related