dynamic list

  1. 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.
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. B

    Creating a Macro for Finding the words within a Dynamic List in a workbook and compiling a Report of the same

    This is a first time I have registered for any of the forums online. I have been working with Excel for quite sometime but only with the Formulae & Formatting and very little with Macros. I have achieved all my goals with the above, but this task has been a bit confusing for me and has confused...
  19. W

    Dynamic List Based on Value in another Cell

    On one worksheet I have a table such as the table below. On another worksheet I have a bunch of lookups that are based off a couple of unique values. Name is repeating, but identifier is not. On another sheet, I need a dynamic drop-down list of all identifiers for a given name. For example, if...
  20. F

    Making a Dynamic List from a Pivot Table

    Hi, I have a very simple pivot table with a long list of Stock tickers (that automatically update and are constantly changing) in the left column, their sector category in the top row, and then the sums of the occurrences of stock tickers in a given sector at the bottom. I want to output to...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top