I have two dropdowns, both use a different source lists and both use the same reference cell to deliver the result, My problem is I need the contents of the cell to be deleted and the new result inserted. At the moment if the cell is already filled the new result is put in the next column.
What I would like to happen is to have two dropdowns one above the other (B2 and B4) and the result in a cell below them in B6, which ever dropdown is used the result will fill the cell B6 this cell is then used for vlookup.
I am trying to get excel to pick a cell from a hiden matrix and showing it on my worksheet. I want to pick the cell using 2 drop down boxes as bellow - 1 drop down picks option on X axis and the second picks using the Y axis and then the coresponding cell in the matrix is displayedMatrix example [URL] Drop downs example [URL]
When I drag my VLOOKUP formula down a column in Excel 2010, the return value copies the formula result from the original VLOOKUP formula result. For example, if the first VLOOKUP returns a value of 0.5, I expect to see 0.5 or 1 in the cell below that one. However, I get 0.5 which is not the expected result for the cell below.
When, I click the fx on the cells below, the expected return values appear in the formula result. After I click OK, the expected formula results updates and now appears in the cell.
I'm not sure what is causing this issue. My computer was updated recently from an old machine to a new one. I have never experienced this issue before.
I am trying to create a form with dropdowns (see attached file), so that when a particular company is selected in the first drop down, the second and third only display the relevant business units and departments respectively.
The INDIRECT function has confused me and I am not sure how to use it.
I am trying to wrap my brain around dependant dropdowns and have hit a brick wall.
Using the Contextures web site [url="http://www.contextures.com/xlDataVal02.html#TwoWord"] I can get part of the problem to work but when I try to add a third dropdown i get lost. Attached is a sample of the workbook.
textbox1 containing the province textbox2 containing the city
If didn't click any value of province the city textbox2 don't have any value and if i click the one of the province the city will now have a value . Is that possible
I'm not a novice but this might be something simple I didn't realize. I am creating a quoting sheet for a steel fab company. I have created dopdowns for the different materials and sizes but the dropdown is way too big. I need to have a column that helps me filter the dropdown more so I don't have to scroll through litterally hundreds of steels to find the one I need. The good news is that most steels have prefixes that make them easier to filter.
For example:
L-3x3x1/2 L-2x2-1/2x1/4
C6@8.2# C8@11.5#
W12@16.0# W21@44.0#
What I'm looking for is a way to have a dropdown that has all of the prefixes (L, C, MC, W, PL, etc) in it and when I select one of them the next column (the actual description of the steel as shown above) will only give me the specific steels for that steel shape (L,C,W,etc)
Currently I'm putting one row of say the MC shapes and one row of the C shapes and one row of the L shapes then copying them as needed. It's a lot of work and you can easily make a mistake.
Biz develop an xls tab that will have dropdowns. Essentially, one dropdown will filter another dropdown... etc... Would also want a DISTINCT list for all dropdowns...
I've used the DropDown's from the CONTROL toolbar and although it seems easy enough to supply a datasource, not sure how filter/distinct might work.
I have a project that has a variable number of worksheets, dependant on the number of models in the job. These worksheets usually only use a single page, but may use two pages if the model is large (not often the case though). I have a "Template1" worksheet that is copied as a whole, to equal the number of models.
To minimize the file size that is generated when copying out the "Template1" worksheet, I have put the template of the second page on a separate worksheet "Template2". Now the initial copy is only of a single page, and the second page is only copied into the new worksheet if needed.
Sub AddPg2() Dim CrntPg As String CrntPg = ThisWorkbook.ActiveSheet. Name Application. ScreenUpdating = False ThisWorkbook.Worksheets("Template2").Visible = True Worksheets("Template2").Activate ActiveSheet.Range("A47:T96").Select Selection.Copy Worksheets(CrntPg).Activate ActiveSheet.Range("A47").Select ActiveSheet.Paste ActiveSheet.Range("D58").Select ThisWorkbook.Worksheets("Template2").Visible = False Application.ScreenUpdating = True End Sub
If I do this process manually, I toggle DesignMode "on", and it works, but I if I record the process, toggling DesignMode does not show in the code. how to include the comboboxes and checkboxes in the copy/paste process.
I have started to create a sales order. I have three columns that I will be working with. I have three lists in a separate worksheet (worksheet 2) in the same workbook. Column A has part numbers. Column B has descriptions of the part numbers in Column A. Column C has prices for the parts in Column A.
I have created a drop down list in Worksheet 1 from the list in Column A in worksheet 2. What I want to do is somehow link column B and C to Column A so that when an item is chosen from the drop down list, the information will pull through.
I need to setup a dropdown list (I already have the dropdown created) so that once a value in the list is used, it disappears from the list. Now for the monkey wrench...It need to completely re-populate once the list that is being generated from it is cleared.
I also need to copy a value from one sheet to another sheet, however, the location needs to be matched with a corresponding value from the first sheet. Hopefully it will be easier to understand within the workbook (I feel like I'm not explaining it well).
I have attached a sample copy of the workbook and what I am trying to accomplish.
I recorded the following macro which deletes specific buttons and drop downs from a sheet. I would like a macro that can delete all Buttons and Drop Downs without them being specified.
I am creating a spreadsheet i want it to be that i make a selection from a drop down and this will then narrow the options available in the next drop down. Say box one you select 'half day' and then the next drop down menu will automatically loose all the data for a 'full day' and only show half day information such as costs for food and room bookings ect. i have made the drop downs but im not sure what to do next.
I am having some trouble with cascading two tier drop down. I cannot seem to find out how to do it. I am trying to create a two tier cascading drop down in form control. I want the first drop down to be Products we have and the second one to be customers. I also want to be able to create a bar chart from these drop downs where after we choose our customer by product, it shows the revenue we have recieved from the customer by months. Is there a way to do this? I figured out how to do this with just one combo box, but I am unable to do a cascading one.
I have my data with column A being the Week ending date (a saturday date) for which the data was entered. In column B it is simply the Month that the data was entered. On another tab...the user can select weekly or monthly. What I would like is a validation drop-down that corresponds to the selection.
IE - If weekly is chosen, the validation will allow the user to select a week that is found in Column A in the data. If monthly is chosen, the validation will show the months from Column B instead. Is it possible to have one validation dropdown, that the validation LIST can be conditionally select based on input in another cell? (A1 being Weekly or Monthly - and B1 being where the validation dropdown would be)
I have several different categories of data, with each list named after the full category title. The data is stored on another worksheet. On the worksheet that will be interacted with, there is a dropdown menu that allows you to choose which category of data you want.
I am trying to get a macro that produces a dropdown menu the next column over of all the items in that category. Here is the code that I have so far.
I've finally figured out the correct code to allow multiple selections from one of my drop down lists. Now, when I try selecting an item from a separate list (which I only want to be able to choose one thing), it's accepting multiple items. How do I have both working properly?
This is the code I have for my multiple selection list (which is only in column M):
Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As String If Target.Count > 1 Then GoTo exitHandler On Error Resume Next
I need to create a page (call it a dashboard) in excel whereby drop down fields (doesn't have to be drop downs, just how I imagine it to work at the moment), are used to refer to information in another worksheet, which updates several charts on the dashboard.
So, for example, I have several additonal tabs in the spreadsheet called 'Company 1', 'Company 2' etc, which in each tab contains information (monthly results) in exactly the same layout and format. However, on the front page, I would like to be able to select 'Company 1' (or 'Company 4') and then sub-select 'March 2014' results within that, referring to the data in the 'Company 1' tab. If possible, it would be handy to have this information displaying in a grid on the dashboard, which updates when you change between months and/or company. This could be the source data for the chart.
I am looking to create a spreadsheet wherein the user can choose multiple drop downs in sequence and then have it output each choice to a template or empty space within the spreadsheet.
For example, lets say column 1 said what is your favourite colour and had a dropdown with two choices red and green. Column 2 says "favourite place" and had a drop down with two choices "London and USA". Then once the user chooses an answer in each column it would output these choices to notepad or a large space within the spreedsheet.
In this example it would output:
"Red London"
if the first two answers were chosen from each column. Obviously it would be a much larger scale than the simple example above.
Got a table where I've placed Data validation - List on them.
Placed a macro on a button so that the data on the table where the validation list is placed is transfered to another sheet (same workbook).
What I need is a to modify the macro assigned to the button so that when the button is clicked to activate the macro:
a.) Can identify if there are any blanks on specified cells with validation list b.) Stops the macro from copying the fields to the other sheet c.) Alert the user of the blanks (an alert stating there is a blank would suffice) d.) Alert should preferably be similar to a Stop alert from Data Validation.
Can anyone help? Been reading through several threads but don't seem to find anything that could help me - tried reading a Visual basic thread and now i've got a headache....
I need to calculate out the loan amount of approved loans by week (weekending on Sunday). For example for the week ending December 28th, 2013
$1,234,567,890 in total loans
I also need to have a list of sums of the loan amounts per code types of approved loans. For the week ending December 28th, 2013
$123,456.00 in total loans for Code: LTV/TLTV > Guideline max $987,654.00 in total loans for Code: FICO > 10 pts below Guideline min
I need to ignore any loan amounts and codes for any loans that have not yet had a approved date entered and also ignore all loan amounts for any loans that are denied. I have tried doing this in many different ways with Pivot Tables and I am not getting the results I need.
Sheet 1 has the following columns on it, with the following possible values. People (Dropdown with value between 1 and 8) Modifier 1 (Dropdown with Text 1, Text 2, Text 3) Modifier 2 (Dropdown with Text 1, Text 2, Text 3) Modifier 3 (Dropdown with Text 1, Text 2, Text 3) Modifier 4 (Dropdown with Text 1, Text 2, Text 3) Result
Sheet 2 Contains a set of values (Distance) that correspond to the value of the People dropdown (ie. People 1 = Distance 5, People 2 = Distance 6 and a table that looks like the following:
Mod 1 Mod 2 Mod 3 Mod 4
Text 1 0 0 0 0
Text 2 2 0.5 0.25 0.25
Text 3 7 1.75 0.875 0.875
What I want to happen is that the Result field value on table one is the result of:
On sheet on I select People = 2, Modifier 1 = Text 3, Modifier 2 = Text 1, Modifier 3 = Text 1, Modifier 4 = Text 1 which I want to result in the following formula:
6*(7 + 0 + 0 + 0)
This might be exceedingly simple, but I just cannot wrap my head around how to do it.
I've attached my .xlsx file for easier understanding.
What I want to do is segment out a contact list by "market area" and "department" and pull the corresponding data with those labels from the Contact List tab into the main tab when validated by the dropdowns.
1.) The Market Area dropdown represents different offices. 2.) The Department dropdown represents departments within each office.
What I want the user to be able to do is to select the 2 dropdowns at the top and view an entire listing of the roster of those departments based on how they are labeled on the Contact List tab. I'm still a relative newbie to vlookup/hlookup so I've tried using them and encountered issues with it returning more than one value or being difficult to fill down the next series of values, etc. I simply want it to return the entire set of employees that fit the identifying dropdowns.
I need to establish a method of interleating multiple dropdowns or Form Control boxes. The purpose is to select one item and have a selection of multiple items associated with the selected item. Example:
Computer training dropdown box 1 offers selections of word, excel, powerpoint, ... If selection is Word, then dropdown box#2 offers advanced in room #15, Intermediate in room #16, Beginning in room #17. If Box 1 selection is excel box 2 selections would be different.
