Using 3 Dropdowns To Return One Line Data

Apr 23, 2012

Based on selecting 3 parameters of respectively 2, 8 and 70 variable ("size", "from" and "to") I would like to have excel return a line of 12 columns.

All data can be listed in 1120 lines x 15 columns (whereof the data in 3 columns are selectable)

Text-based data (container sized and port names, if you're curious) and the data (transport prices and conditions) are both numeric and text-based.

I'm familiar with VLOOKUP, but this stuff looks to be a bit above me...

View 7 Replies


Dynamic Data Validation Dropdowns

Dec 17, 2013

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.


View 2 Replies View Related

Data Validation Dropdowns (Dependant Lists)?

Oct 22, 2007

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.

View 3 Replies View Related

Read Pdf Or Doc File Line By Line And Then Parse Data Into Proper Cells And Rows?

Feb 23, 2013

I have the data to import / read in a pdf, in a doc, or in an Excel worksheet whichever is easier to use. I need to import the data, parse it into the correct cells for that row and then repeat the import until the end of the file. Not all the cells are in each group of data to import, so those cells will be null for that row. Some of the data for one cell may be in up to 14 lines in the data file. I have be concatenating these data rows into one cell. There are 48,000 lines in the file to import or I would do this manually. I am assuming that doing this in VBA would be the most efficient method.

View 11 Replies View Related

Compiling Data From Multiple Workbook Into A Line By Line Master Schedule

Mar 30, 2013

I have about 180 workbooks which I need to compile into a Master Schedule.

All the tab 1's are different, these feed into tab 2, which the data has the same formatting throughout. The 2nd tab has the same data for A:F 1 but cells A:2 - F:2 down to row 9 are populated from tab 1, therefore different in each. I am trying to get a Master schedule that lifts the data in the fed cells into a line by line spreadsheet?

Is there a way I can get excel to look at a folder, then every workbook in it, the at the 2nd tab in every workbook, then list the cells as described above? I am not after a consolidation of this data, but a full list?

View 1 Replies View Related

Read Range Of Data Line By Line Which Is Increasing Dynamically

Aug 20, 2014

I need to read or clear all the line in specific range which will be increasing dynamically. Problem is "Selected File List" table range is not specified. New file chosen with browse will be added to "Selected File List" dynamically. Number of file can't be predicted.


What I've tried so far is, keep track of the browse button click and add the file path to arraylist. After that, (Row number 9 which is start line + arraylist size) to get the number of line of end of the table. But due to some requirement, I want to read the file from excel file. Something like -Read until found blank line or border bottom or something.

I'm new to VBA and I'm not so sure what I'm doing with vba codes

View 1 Replies View Related

Inserting Carriage Return And Line Feed?

Dec 29, 2011

I've written this code:

=IF(((BP3="1")*AND(C3="Visit")),"The following code rule is being tested: "&D3&". This test is for the Family Practice specialty.","")

What I need to do is insert a carriage return/line feed right before the first & sign so that it is easier to read.

View 2 Replies View Related

Start New Line Pushing Enter/Return In TextBox

Nov 8, 2006

Is it possible to change the behaviour of the return button within a textbox? What I would like is, once the return button is pressed, it starts a new line in the textbox rather than it moving to the next textbox within the form.

View 3 Replies View Related

Replace Line Feed With Carriage Return In Text File

Sep 11, 2007

If I write a multi-line text in a cell (then go down with alt+enter) and after copy the cell pasting on Notepad, it display before inverted commas and after textual content.

Instead, if I select directly the content from the formula bar, it isn't happen.

Do exist a way for copy and paste directly from the cell without select from the formula bar?

Maybe with a macro?

View 5 Replies View Related

Validating Dropdowns In IE Using VBA?

Oct 5, 2013

I have a drop down in IE in which four values are there

I will need to select each one at at time to make some change and move to next dropdown

the dropdown in IE should ideally have 4 dropdowns 01,02,03 and 04

However due to vendor errors we may have any of the above missing from dropdown or extra orderpoints in the dropdown like 05

IE.document.getElementById("vendororderpoint").value ="01" is the code to select order point 01

I need an alert in excel if any of the 4 dropdowns is missing.

View 1 Replies View Related

Selective Dropdowns

Feb 13, 2009

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.

View 4 Replies View Related

Dependent Dropdowns

Dec 30, 2009

I am trying to wrap my brain around dependant dropdowns and have hit a brick wall.

Using the Contextures web site [url=""] 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.

View 5 Replies View Related

Province And City Dropdowns

Sep 5, 2013

I have

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

Here is the picture : [URL] .....

View 6 Replies View Related

Filtering In Dropdowns With A Prefix

Feb 20, 2010

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:




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.

View 12 Replies View Related

2 Dropdowns Same Cell Result

Dec 7, 2011

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.

View 2 Replies View Related

Dropdowns Moving When Running VBA

Jun 10, 2013

I have this code:

Sub comments1()
With ActiveSheet
With .Rows("180:186")
.Hidden = Not .Hidden
End With


Now, when I run this code, sometimes (but oddly not every time) the dropdowns do not reappear where they were originally placed.

View 1 Replies View Related

Populating Responsive Dropdowns WITHOUT VBA

Jan 16, 2009

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.

View 9 Replies View Related

Copying Dropdowns Between Worksheets

Mar 8, 2007

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
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.

View 8 Replies View Related

Creating Sales Order With Dropdowns?

Apr 22, 2014

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.

View 5 Replies View Related

Dependent Dropdowns From A Sorted List

May 1, 2009

Dependent Dropdowns from a Sorted List:

i have one file here..

how did they created validation here.

is there any macros?

i tried..but i didnt able creat like this.

i got this file in this link.

i saw this problem in this post..

View 6 Replies View Related

Delete All Button And Dropdowns From Sheet

Jan 29, 2010

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.

View 3 Replies View Related

Searching On Dropdowns For Closest Match

Feb 6, 2012

Is there a way to set up drop downs so that you can type in the drop down box and it searches for the closest match?

View 1 Replies View Related

Picking Matrix Cell Using Dropdowns?

Mar 26, 2013

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]

View 4 Replies View Related

Cascading Two Tier Dropdowns In Form Control

Jun 4, 2013

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.

View 5 Replies View Related

Conditional Validation Dropdowns That Corresponds To The Selection

Nov 10, 2008

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)

View 2 Replies View Related

Triggering Different Dropdowns Based On Original Dropdown

May 12, 2009

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.

View 5 Replies View Related

Single And Multiple Choice Dropdowns In Same Worksheet

Mar 23, 2012

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


View 2 Replies View Related

Double Click Row To Return Data To Userform For Edit Then Return Back To Sheet

Jan 30, 2014

I am trying to create a data entry sheet to enter quotes on. When a quote is received, I click on my "Add quote" button and a userform appears. Data is entered into the userform (frmEntryForm) and returned back to the next available row.

I also need to be able to:

Edit a row by double-clicking it. When a row is double-clicked, data from that row is passed back to the userform, edited and returned back to the same row (to prevent duplicates).Validate that all fields are complete within the userform where relevant (i.e. if the work is not complete or in progress then the "Invoice Number" and "Actual Cost" fields are disabled and blanked to prevent entry (I think this is almost sorted judging by my tests)

I have attached my sheet : 2014 Gatwick Quote Log (Macro Enabled).xlsm‎

View 14 Replies View Related

Dropdowns Used To Reference Information In Various Worksheets To Update Charts?

Apr 23, 2014

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.

View 1 Replies View Related

Spreadsheet - Output Choices / Multiple Dropdowns In Sequence

Mar 14, 2014

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:


if the first two answers were chosen from each column. Obviously it would be a much larger scale than the simple example above.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved