scripting dictionary

  1. H

    Compare multiple column using dictionary VBA

    Hi everybody, I am hoping someone might be able to help with this problem I have 5 columns in sheet1 column A have all the names of employee that attendant today Column B have the names of all employees of department 1 Column C have the names of all employees of department 2 and so on till...
  2. G

    Filter Table Column, pull Results from another column into an array to filter out duplicates and paste on another sheet

    Greetings all, this is my first posting as I can't seem to find the answer despite some serious research. What I need to accomplish: 1. I have a table and I want to filter on Column 1 for a specific word (in this case Management) 2. Then I want to copy the filtered results from Column 5 - ONLY...
  3. M

    Excel VBA Scripting Dictionary Output Issue

    In VBA I have created a scripting dictionary called finDict that contains ~72k keys and items. I'm trying to write the list of keys to a worksheet. The code below correctly prints all of the keys in finDict, but it is extremely slow: For Z = 1 To finDict.Count...
  4. J

    Scripting Dictionary help when there is a comma in the string

    Hello, I am looking for some assistance in using a Scripting Dictionary to read a column of data and store unique values for output into a list. The problem i am coming across is the Scripting Dictionary is parsing lines in separately when it sees a comma. For example: AL - Medical Group...
  5. W

    Vba lookup 2 criteria scripting dictionary

    Hello, I kindly request some help regarding a lookup according two criteria that I would like to set up with scripting dictionary. what I have 1 workbook, 2 worksheets First worksheet ("datasheet") contains in column A (the different questions= 1st criteria), in column B (pool participants...
  6. D

    Combobox at run time .add from range and use scripting dictionary

    Hi, I have created a userform which populates with comboboxes at run time. How do I populate them from a range. and use scripting.dictionary I have done this before with a combobox at design, how do I structure the code referring to dynamic controls (SName & i)? With...
  7. M

    Need to aggregate data on a filtered result whitout changing the original data

    Hi, I have a material list for different work orders, each work order may have the same material called multiple time. I want to filter my desired work order and have a clean and aggregated data, without and duplication of materials, while their quantity is aggregated. I want to have the...
  8. T

    Run time Error 13

    Hi, Vlookups were taking forever so I wrote the below code to use the scripting dictionary. It works fine on smaller amounts of data but I am getting the Run time error on my "live run". I assume it is due to the size of my data. how can I fix this. My work sheets are between 250k and 350k+...
  9. B

    Advice on Approach: Collection, Array or Scripting Dictionary?

    Hello, I'm fairly new to VBA, but am becoming more proficient each day. I wanted some advice on the best approach to collect, aggregate and print out data from this sample workbook. (if you would prefer me to post the workbook another way- please advise. No macros or anything in this workbook)...
  10. M

    Indexing/scripting code issue

    I have a userform with 3 dropdowns. The first is Dept. Name, the second is products, the 3rd is completed products. The user chooses a dept and then a product and is directed to the worksheet for that product and determines some pricing levels. When the user clicks the "accept" button on the...
  11. T

    VBA: Calling Scripting.Dictionary Values Using a Column as a Key

    Hello all, I have a Master list of 230k IDs that correspond to different values depending on the raw data source. I have 30 Source sheets with ~140k IDs each, the sort and number of which are unique to each sheet. The Source sheets contain 2 columns, an ID column and a value ("Bucket") column...
  12. D

    Importing Large CSV File into Excel Using VBA

    The below code works, but for whatever reason it doesn't seem to recognize the commas which need to be taken into account since the data is comma delimited: Sub Import_Large_Textfiles_DAO() 'Note: A reference must be set to Microsoft DAO 3.5 or 3.51 'Note: A reference must be set to Microsoft...
  13. D

    Combining Macro's

    Hi everyone I'm trying to combine the two macro's below so that they can be ran from one button. I'm struggling because of the scripting.dictionary. Because both macro's use this object, I'm not sure if it is possible to combine them. Any thoughts? Sub delete_duplicate_invoice_values() Dim Rng...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top