Any way to display the description of options (list) which in this case is a numbering code (like ECG201) in a data validation cell.
The length of the cell is not long enough for the users to know the appropriate description of the selected lists. I am now thinking there should be a way to display the description of each item so that users will know that ECG201 means "International College of Excellence", for example, instead of having to go from one worksheet (area) to another to know what an option means.
When the user enters a date (A1), that date is cross-referenced with a database to determine 1 of 3 results, in which the results are displayed in A3 as follows - Date out of range. (value="DOR"), No records exist. (Value="NRE"), Records exist. (Value="RE").
Once the date is entered and the corresponding value determined, I would like to have a ppo-up message appear with options:
Date out of Range. Message: "Date falls out of range of operating season. Please re-enter." ** I think I can use validation to take care of this. **
Message "Would you like to import data?" Yes - open external application No - default A1 to current date and await user input
Records Exist. Message " x Diamond Records; y Field Records; z Court Records " where x y z are numeric values based on lookup from the referenced database Message "Proceed to data" Yes - takes used to next new worksheep No - default A1 to current date and await user input
How / where do I code this to activate after the user enters a valid date?
I need to build a formula to have one cell display multiple options depending on a value in another box.
If Value is >x and <x display Y
Details:
Cell D5 Holds a dollar amount. E5 is where the calculation will happen. Logically i need it to do the following exactly:
If D5 is between 5000 and 9999, display 75. If D5 is between 10000 and 14999 display 150. If D5 is between 15000 and 19999 display 200. If D5 is >20000 display 250.
is it possible to do the following with a drop down list, without requiring VBA? I would like to have 20 products to choose from in a drop down box. When the user selects one of the products, a more detailed product description will appear in the same cell where the drop down list is. For ex: If the user chose "chair" from the drop down list, what I would like to appear in the same cell is "chair - model T654".
I have created a drop down list, but when selected the text is really small. I know this is because I am zoomed out, but if there any way for the text to be larger so that I can zoom out and still read what the options for the dropdown list are?
For my school project, I must create a spreadsheet with lists. I am not allowed to have the data from the lists displayed anywhere on the sheet except for the results which will be hidden by the list (Combo box) in question. I have 3 such combo boxes and I need the options inside them to be hard coded into the spreadsheet. How do I do this?
I want to write a macro that asks the user for input, but not any input. The input has to be either "D", "IK" or "CI". I would like for the user to have to select one of these options.
It's a quarterly schedule for utility meter readers, divided up into days across the top, and routes/areas down the side. There's a space with each route for the employee ID to go, depending on who's doing it.
Down the bottom of the sheet, there's a few empty lines for all the available employees who haven't been allocated to a route.
On the second sheet labelled EMP LIST, is all the employee IDs. It's also got the areas they work- it's for something I want to implement later.
I can put all the employees into a single column list, then use basic DV to give a dropdown menu by each route, to assign an employee to it. This is pretty straight forward. I've also been playing with this in combination with a countif, so that employees already assigned do not appear in the list.
This is about as far as I've managed to get with it.
I need to get the employees who aren't assigned to anything to appear in a list below the routes. I'm fairly sure this is just another countif, but I'm not 100% on the exact formulas.
I also need the list in the dropdown menu to reset for each day of the quarter, i.e. if I assign an employee to a route on the 30th day of the quarter, their ID will disappear from the list for any other route for that day, but will still be there for the other days of the quarter.
So far the only way I've managed to do this is by duplicating the employee list for every day of the quarter, which is going to get very cluttered, and also makes staffing changes difficult. I'm hoping there's an easier way to do this using one data set.
I've added an example of the sheet. It's one week and it's only got about 1/3 of the routes we would actually have on any given day.
In my example you will see my name list that changes with a array to data validation. Seems like you can find ways around things most of the time but this time
is there a way to get a cell to display a list, but only in one cell? I know how to get multiple words into a cell, but can i make them go ontop of eachother. ex) a1=dog b1=cat I can make c1=dog cat , but is it possible to make c1= dog cat
I am developing a workbook, one part of the book is to track discipline I have a page for this and a userform on the front page to enter data into it. I would like if you will a summary box (list box or whatever is best) displayed on the front page and I would like a line to appear in that box maybe saying john smith requires a warning. I need this to appear if john smith has been entered 3 times into the name column on the discipline sheet however only if the offence is the same 3 times for example 3 lates not 2 lates and 1 non attendance.
After it displays this line in the summary box I would like to be able to double click it where a small userform appears where a user can then select discipline received or something and for this lien to disappear in the summary and all 3 entries in the discipline sheet.
I'm trying to replicate the VBA code for displaying scenarios using a drop-down list that I found on this website: http://www.tvmcalcs.com/blog/comment...rop_down_list/
However, I've not quite been able to get it to work on my worksheet. This is my
I have a workbook that lists various shipment numbers and their contents to several locations. What I am trying to do is, on a different worksheet in the same workbook, list all shipments to one location; having different worksheets for each specific location.
I am sure there must be an extremely simple solution to this, however I am unable to locate it.
Also I would like the separate location worksheets to autoupdate when new shipments are entered on the main worksheet.
How could I create a menu that displays cells from another sheet when the appropriate menu value is selected?
For example, the menu (on sheet 3) would have:
Week 1 Week 2 Week 3
If I select Week 1, I want to display cells B4:B10 from sheet 2 underneath the menu. If I select Week 2, I want it to display cells B19:B25 from sheet 2 under the menu.
I need to be able to display a list of values from a drop down window. When the value in the drop down window is selected I need to have the data populated in the rows to the right of the drop down window. I have created the Drop Down using data validation in B12, I need C12 & D12 to auto fill with the info listed in H2 & I1 according to the item picked in the drop down.
I have tried to follow an example listed on the website but i keep getting a formula error.
I have a problem with this workbook, i know how to do it by nesting if functions but i want a neater way to do this. I have tried if(index(match)) type formula and haven't got it to work.
I am trying to create a schedule that will randomly populate with names from a list. I have learned how to do this with numbers. How can I do this with a list of names? How can I make sure that no names repeat?
In one column, I used =RAND()
In the cells where my numbers display, I used =INDEX(ROW($A$1:$A$24),RANK(Z17,$Z$1:$Z$24))
I have five comboboxes in userform1, they are link to Column A, Column B, COlumn E, Column G and Column Z of "Reference" worksheets respectively. The values in each column could contain duplicate values. However, I'd like to only display the unique values in those combo boxes and I have no clue how to achieve this.
data validation to display a list of values. The problem am facing is .. this list has a lot of names & it becomes difficult to scroll through when i need to search for a particular name.. Is it possible that when I press a key on my keyboard, the name starting with that letter is highlighted in the drop down list.. This is not happening automatically using data validation... Is there a work aorund for this?
II have a list of football fixtures (see attached sheet - barclays premiership) each with a different status Win,Loss,Draw,Pending. I want to display the next team with a Pending status in a cell at the top of the list (cell T13/14) so the user knows at a glance what the next fixture is. I also want to display the days remaining to that fixture in the cells below this (cell T15/17).
I have designed a multiple list box on my userform and display it on one of the cells in the spreadsheet but with each list item separated by a comma when its display on excel.
The problem with my code is the delimiter appears at the first list item, but it should only appear if more than one list item is chosen.
|Apple|Orange
I was thinking if there is something like if gItem = 0 then only display sFruits Else display what I have below???
VB: For gItem = 0 To FruitsList.ListCount - 1 If FruitsList.Selected(gItem) = True Then sFruits = sFruits & delimiter4 & FruitsList.List(gItem) End If Next .Cells(gRow, "AO").Value = sFruits
I would like to be able to display all of the sheets in a workbook as a list on the front sheet.
I have a front "Contents" Sheet (attached at the bottom of my post)
In the "Ticket No." column I wanted to have the sheet name, in the "Date" and "Description" column I wanted to display cell values from each sheet; which would be the date and description of that sheet/"Ticket". The "Resolved?" column I will be able to do after I have this part figured out.
I am trying to get the list of all files contained within a directory and have them displayed in a confirmation box, listed one beneath the other (as a column, each file name in a new row).
I have my Employees List in one Sheet and in another Sheet2 I want to Display those Employees Names and List whose Passport going to Expire in the dates entered in Sheet2 A1 and B2 Cell.
