dynamic list

  1. S

    Using VBA to search for a specific Class Element in a website source code for a dynamic list of search terms

    What I am trying to do, is to paste a term from a list into a search bar and then return a value into the spreadsheet depending on whether the search yields results or not. I would like the VBA code to cycle through the list of items automatically. Search term from Column A1 - Output if class...
  2. R

    Dynamic Table References for Data Validation Lists

    I've been tinkering for a while, but just can't seem to get this to work as desired. I have multiple tables in a workbook: TblFuel TblVehicles TblPlant_Machinery TblMaterials TblLabour I'm creating a quote page where the initial selection is for one of these item types(Fuel, Vehicle...
  3. R

    How do we using dynamic list based on condition criteria from cell value?

    We using dropdown dynamic list from master using OFFSET function for except blank data's, Here, we would like to next two columns lists should allow/block based on the previous column list value, Kindly help us anyone, how to do this functions in excel? Eg: In above example, First List...
  4. D

    OFFSET MATCH (WITHIN DATA VALIDATION) MISMATCH??

    For some reason my match is exactly 1 cell down from where it needs to start and I have not been able to figure out why. Customer A should come up 1,2,3 but I'm Getting 2,3,4 =OFFSET('Customer Info'!$A$1,MATCH($B$1,'Customer Info'!$A:$A,0),1,COUNTIF('Customer Info'!$A:$A,$B$1)) Thank you.
  5. B

    dynamically generated list

    I run a window cleaning company and use Excel for accounting. I have a page that has all my customers. There is a column that has the month which shows the month their windows are due to be cleaned again. On my dashboard, I want to show all the customers due to have their windows cleaned for...
  6. Johnny Thunder

    VBA Help - Dynamic Named Ranges for Drop Down List - Excel 2016

    Hello All, I am working on a new project and I have hit a road block. I have searched the interwebs for a solution to my problem but was unable to find a solution I could cater to my issue. My Problem I have a List Column A ("A1:A64") of Unit numbers and in Column B a corresponding list...
  7. Q

    Dependable Dynamic Unique List

    Hello, I have data from which i need to extract unique list. i have everything up and running but my data has lot more rows n columns and excel takes forever to calculate it. Please suggest way to simplify these formulas to cut back on processing time or any if there is other way to get the...
  8. Q

    Help with dynamic unique list

    i have data from which i need to extract unique list. i have everything up and running but my data has lot more rows n columns and excel takes forever to calculate it. Please suggest way to simplify these formula to cut back on processing time or any other way to get the desired dynamic list...
  9. D

    User input data setup box

    I want to create a setup form where users can create items that will go into a named range used in data validation lists. I know how to create a user input form to get it to populate into one certain cell, but not in an undetermined range, like I need here. I have already created all the...
  10. Johnny Thunder

    VBA Help - Looping thru a list of values and copy/Paste into another workbook and create a .txt file with the new criteria

    Hello All, I am working on a project and needed some help with code. What I am trying to achieve; Step 1 "Sheet 1" - Contains my list of unique values in Column A - Range A2:A50 - there are 3 blank rows before the next new unique value is found, for example: 1st value is in cell A2...
  11. J

    Dynamic Chart ignores new input

    Hello again! I have a dynamic chart based on a named range. It displays the percentage of the subject (specific column) of all papers (each is a line) listed on the range, named "main_tab". If it matters the "main_tab" range is also "dynamic" (not a fix range, but uses OFFSET and COUNTA...
  12. D

    Source in Data Validation to long

    Hy all! I have 25 dynamic lists and i need to make a cell with data validation that shows me a list according to the first cell value. I used Name Manager to create the lists (A-Y to shorten the length... C & R was not allowed so i used CC & RR), but the formula in Data Validation Source is to...
  13. M

    Return a list of text values without blank cells from a column

    I have 6 columns: A=code, B=color (drop down list), C=checked(1) - only "+", D=checked(2) - only "+", E=A and B, F=show E, which checked(1) only. It looks like this: A B C D E F 123 black...
  14. A

    How to insert a dynamic CC email list from Excel column into VBA

    I am brand new to VBA and I am trying to automate daily emails by setting up a macro in Excel to send these emails based upon a daily-updated Excel spreadsheet. I was able to utilize Ron de Bruin's website - example 2 from the one titled "mail a row or rows to each person in a range". The...
  15. L

    Display Pivot Table Based on Defined Name List

    Hello - I have a worksheet where I have a drop down list and 6 names to pick from (we'll name this worksheet "Selection"). Additionally, I have 6 other worksheets, each containing one pivot table that belongs to one of the 6 names on my drop down list. I would like to pick any of the 6 names...
  16. M

    Dynamic list of values based on dataset

    I am trying to create a dynamic list of unique values, based on the value of a single cell that can be found in the dataset being used. My dataset is 2 columns: Pool Manager 1 John 1 John 1 John 1 Mike 1 Mike 1 Cary 2 John 2 Mike 2 Lester So, if I enter 1 into the reference cell, I...
  17. F

    How Can I Create A Dynamic List that Updates based upon certain Criteria?

    Hi, I am trying to create a dynamic list that automatically lists only both removes duplicates, as well as filters only by what is in the column next to it. With my example below, I want all the blue and green items (blue as labeled in Column B) in Column A to be put into a list in Column E...
  18. W

    Sort and order a dynamic list based upon other criteria?

    This question is a variation of the one discussed in this thread. Say I have the data below in a worksheet. I would like to put a list on another worksheet that shows the undrafted (Drafted? = "No") wide receivers (Position = "WR") sorted in Ranking order. That way, my list of available wide...
  19. D

    Want to Create a Dynamic List Excel based on a few columns in another sheet .

    Hi experts, I have "sheet 1" which has two columns -1) Positions 2) Codes In "sheet 2" I want to give some "Codes" input in Cell(B2) and based on value of the cell in B2 , the macro should be able to populate a list of all positions which matches the "Codes" from cells B4 downwards . Also...
  20. G

    Problem creating a Dynamic List on a separate Sheet

    How do I create a dynamic list on a separate worksheet? I have included an example of how I want it to look. There is a list of Employees, The offices where they work, and their titles. On a separate worksheet, I want it to dynamically create a list of each employee by the office that they...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top