I would like to be able to limit a drop down list's contents based on a user's selection in a different drop down. I am using Excel 2003, and I know how to do this in Access, but I can't figure it out in Excel. Basically, I have a list of themes in one drop down. The user picks a theme, and goes to a second drop down which is a list of sub-themes attributable to that one theme and no other theme.
View 1 RepliesIf a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.
View 1 Replies View Related[URL]....When I select a name in column B, it populates column C's dropdown with that name's list of units. When I select a unity type in column C, I'd like it to automatically populate column E in the same row with the value associated with that unit. The values associated with a particular unit can be found to the right of the sheet. So if in row 2 I select Blake in column B, then Unit 5 in column C, I'd like column E to be populated with 14.
Edit: using Excel 2007.
I attached stripped down version of the sheet which is small enough to post. None of the things I removed should affect the topic at hand. The full sheet is available at rapidshare.
i am considering the use of custom menus in an Excel application. is it possible to limit the selection of menu items for each worksheet? for example, sheet 1 all menu items are available, sheet 2 all but 2 menu items are available, sheet 3 all but 5 items are available.
View 10 Replies View RelatedI have some data validation drop down lists in excel, I can tab through all the lists but I have to press alt + down arrow to show the list, Is their a way it can be automatically shown as soon as I focus on the tab.
Check the attachment: Survey.xlsx
I am new to VB macros, I am trying to figure out how to color a tab Green based on a selection from a drop down list.
View 9 Replies View RelatedI need to make a dropdown list (I know how to do that) and based on that selection, I need some cells below to automatically complete. How can I do that? Is it possible with or without VBA?
View 5 Replies View RelatedI've created seven names in my data validation source list on Sheet 3 in the following range of cells, A2-A7. My data drop down validation list is located on Sheet 1, A2 in the same workbook. I would like to trigger a macro based on the name I select in this drop validation drop down list that will fill out an address, telephone number, and email address in the following cells next to my data validation drop down list on Sheet 1: B2, B3, and B4. I want it to be designed so that users will select a name and have that person's corresponding address, telephone number, and email address fill right next to their name on the same sheet.
View 6 Replies View RelatedIs it possible to do a drop down list that allow user to select pre-defined selections but everytime when a selection is chosen, the list reduced?
Example,
I have can choose Apple, Orange, Durian and Mango.
The drop down can only select these 4 fruits.
So there are 4 cells in Column A1, A2, A3, A4.
A1 selects Mango and then A2 will only have 3 options to choose. So until the last cell, he can only choose the last fruit left.
A1, A2, A3, A4 are not selecting in descending order thus it could be A3 selecting first, then A2 and then A4.
I'm using excel 2007
I have a workbook that has two worksheets. One worksheet is an input worksheet. A user will select a date from a drop-down list and type in the events that occurred on that date in 8 adjacent cells. The user selects a button that advances date and clears form. On sheet 2, whatever was typed into sheet one is saved via VLOOKUP formula. However, if I try to change something retroactively and select a previous date from the drop-down list, it clears everything in sheet 2 that was typed for any selected day.
View 1 Replies View RelatedI am trying to limit the user from selecting only what has been selected from the first selector. The selection are based on a drop down (data Validation list)
Excel 2007BCDEFGHIJ1LOOKUP Table2Should only allow from 3only what availble from First SelectorBus/Cntry Level 2Bus/Cntry Level 14ALLALL5First SelectorSecond SelectorAPACALL6TerritoryAPACAPACAPAC Regional Office7APACAsia Licensees8APACAustralia9APACChina10APACHong
[Code] .........
I have a spreadsheet that has a long list of charges... some of those charges have multiple codes attached to them... when this happens I am wanting to group them together and let the user pick which one they want to view at one time.
Here is a very small example of what exactly I am referring to... with charge #14 I am wanting it to combine and let the user pick between 2565 and 2566. The problem is that the values can range and will not always be 2565 & 2566 and there is 10,000 + records similar to this.
test.xlsx
I have a workbook that has 30 tabs in it. Each tab is a report card for students. What I'd like to do is create another tab with a button on it that when I hit the button it will search through each tabs range of D12:D40, D48:D76, D84:D112, D120:D136, J12:J40, J48:J76, J84:J112, and J120:J136. And if any of these cells has an MS in them then this new sheet I have created will list each students name which is in cell E5 and list what they recieved the MS for. This will be in the same row number but in column B. So if cell D12 has an MS in it then this report will list the students name and what's in cell B12.
Windows XP
Excel 2003
I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
View 7 Replies View RelatedI am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
View 5 Replies View RelatedI created a very simple user form to input some data into a spreadsheet. I have a list box and this is my button code to input the data to a cell.
View 6 Replies View RelatedI have a calendar that enters a date into a spreadsheet cell. How can I modify the code to limit the day selection to a Monday?
The current code is:
Option Explicit
Private Sub Calendar1_Click()
Range("V2").Select
ActiveCell = Calendar1.Value
ActiveCell.NumberFormat = "dd/mm/yy"
frmSchStartDate.Hide
End Sub
Private Sub UserForm_Activate()
Me.Calendar1.Value = Date
End Sub
I am trying to create 2 drop-down lists (based on named ranges), where the contents of the second selection change based on the first selection. On one sheet, I have a list of equipment that is quite long, but is broken up by categories. I have named ranges for all the category names, and the equipment in each category. On the other sheet (user side) I made the first drop down the list of categories, and would like the 2nd drop down to be the pieces of equipment that correspond with the chosen category. I have tried using data validation and nesting IF formulas, but it only works for the first 4-5 categories, bc my formula is longer than the Source field allows in Data Validation. Any other way I can make this work? Can I use a macro for this? If so, how to write it as this would be my first macro
View 9 Replies View RelatedI am looking to write a code to lock/unlock cells based on values selected using a drop down list (see attached Excel) For example if Netherlands is chosen as the Country (Column A), then except for the columns Amsterdam (column B) and Eindhoven (column C), all other columns must be locked. Similarly, if India is chosen as the country from the drop down list, then only the columns New Delhi and Mumbai must be editable for the user, the rest of the columns remain locked.
I tried tweaking some of the lock/unlock codes around, but got lost especially with getting to run the macro - still trying to come to terms with running a "Private Sub Worksheet_SelectionChange" function in the sheet from "Module"!
how to create drop down lists which is making a sales forecast template for my small company look pretty jazzy. Of course, now I want more out of it and can't figure it out.
I successfully added a drop down list for a sales person to pick a supplier, let's say their selection populates cell E4. Once selected, the next cell over (F4) gives them another drop down list with the products made by that particular supplier. The next cell over (G4) is in a column titled "Unit Cost", how can I make the Unit Cost cell populate automatically when the product selection is made in F4?
NOTE: My "lists" are on Sheet 1 along with my working spreadsheet. I have a Suppliers List, Products List (for each supplier), and anticipate I will need a Price List for each Product List, right?
Once I finish the spreadsheet can I cut and paste all the data to sheet 2 (I put it 100 rows below my spreadsheet to hide it)?
auto fill the rows after selecting a particular option from a drop down list. For Ex., In Drop down list we have Cool drinks and Ice cream as two options. If i select Cool drinks the respective columns should be filled with brands like, Coke, 7 Up etc...
View 3 Replies View RelatedI am working on Excel document(Microsoft office-2007) with 2 sheets(Sheet1,Sheet2).
In sheet1 i have a dropdown list and the respective data is saved in Sheet2.On selection of dropdown lists in sheet1 ,respective rows should get copied from Sheet2 to Sheet1.
I am having trouble with the macro command. This is a first for me and I am stuck. I just dont know the how to write the Macro for this.
How do I allow the user to select from a dropdown list but disallow them from entering value into the textbox?
View 1 Replies View RelatedI know how to create a basic dropdown list, but what I don't know (I don't even know if it is possible to do at all) is how to allow user type-in response if the "Other (please specify)" option is used.
Column A
Question 1. What type of report are you using?
Column B will contain
Type I Report
Type II Report
Other (please specify)
If Type I or II is chosen from the list, I don't want user to be able to change anything. But If the Other (please specify) option is selected I would like to give user an ability to type in type of the report he/she is using. Also, is there a way to have list options chosen based on another list response?
How to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.
Attached files for reference :
Dropdown Month.xlsx
MONTHLY DATA.xlsx
I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.
What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.
ddl.png
[URL]
Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?
I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.
I have a workbook in Excel that runs some code when it is opened [see below].
It works fine for everybody except one person using Excel 2003 - they get a Run-time error '5' : invalid procedure call or argument message and I cannot figure out why.
[Code] ......
I'm creating some userforms for a spreadsheet on Excel 2003 and was wondering if it is possible to have the date field and time field as drop down boxes?
I would ideally like the date field to have 3 drop down boxes (date, month and year) and then the time field to have 2 drop down boxes (hours (in 24 hour time) and minutes).
The date and time would then populate one cell each on the spreadsheet.
I have created a User Form that has been tested and is working properly. Now my last step is to do the following:
I would like to Display the User Form (coded as CommRM) if in Column C (can be any cell as it is a large worksheet) someone selects "Retail News" from the drop down option.
The code that I have been able to create so far is below. The problem is that when I select Retail News from a drop down in Column C the user form does not appear.
VB:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range (C14, C3333).Text = "Retail News" Then Call UserForm_Initialize
End Sub
Private Sub UserForm_Initialize()
Load CommRM
CommRM.Show
End Sub
I have a excel file to keep track of sales pipeline. What I am looking for, is an automated utility or code that will allow excel to automatically move entire rows once a task is completed and can be moved to another sheet. In Prospects sheet I have a column for " Stage" and here you have to select from a drop down menu, either "Prospect", "Contacted" "quoted" "WON" "LOST" What I would like, is that once you have selected one of the sales stage, the entire row or entry, will be automatically moved to the right tab from the "prospects" to a new sheet according to each stage.
SalesPipeline.xlsx