dictionary

Hi - I have two sets of employee data from two sources, both in separate worksheets within the same workbook. Both sets of data have same 5 columns, e.g employee number, employee name, line manager, email address and department. I need to compare (based on the unique employee number) of any of...

Hi All, This is my first post in the forum. Looking forward for help from the members. Need a VBA code that will fetch data from a closed file using ADOBD.Connection into a dictionary and in the dictionary create an additional column for vlookup. Finally paste the data into the activeworkbook...

Here is a snippet of my code: Set Results = New Dictionary For i = 2 To UBound(Mainarray) TheDate = Mainarray(i, 1) ' If team one is not already in dictionary then add Results.CompareMode = TextCompare If Results.Exists(TheDate) Then 'Results(TheDate) = Mainarray(Ecount, 1)...

Hi, Im trying to use autofilter to filter in columns by using the values that are stored in an array or collection as criteria . I already know it is ok with array but when ım trying that with collection I couldnt achieve my aim so far and ım just wondering it is possible or not ? Im sharing...

Hi All, I'm having some troubles calling the value in a dictionary, I assume it's a simple syntax issue so hopefully someone will be able to educate me easily enough. I'm also not 100% sure that a dictionary is the best/easiest way to go about doing what I'm doing, so I'm open to alternative...

Hello dear helpfull mrexcel friends..i need help please. very important .thanks i have two excel file for dictionary. Both are for two languages . both are with columns. word and meaning. but one language of two dictionaries is same. for example i have English-kurdish and kurdis-persian files...

Hi! I have a complex problem that I've spent hours searching up solutions for, but haven't been able to find what I need. I'm looking for a VBA code that will do the following: Look at a list of user-inputted data on Sheet1 (Something like A1=Potato, A2 = Cabbage, A3 = Turnips) Check this...

Hello, I do quite a bit of work with excel for my job, but this is a task I am stumped on. I have millions of lines of data, and I am looking for words within text strings. There are no spaces, and many of the lines are gibberish (random numbers and letters together), while some contain words...

Hi, I need to paste the records of a dictionary that has 3 items into a worksheet but I can't come up with any algorithm because I just started using dictionaries and classes. Can you please give me an example of how to do this? The data from my dictionary looks something like this: <tbody>...

Greetings All!! Introduction: I hope all is well. I am attempting to create a system where the user can log which date and time they will not be available to come into work. The day is a 24hr day, and there are 4 shifts within each day (presumably 6hr increments). I just want the user to...

Hi! I've been stuck with this for a couple of days now, any help would be appreciated! :) I'm looping through a folder and retrieving some technical drawings. This works just fine, but I can't access the items correctly. The drawings follow this naming structure: Drawing_RevisionNumber_Type...

Hi - I'm attempting to create a code which I can create an email body based on 3 criteria - whether a column is checked to send an email (aCell.offset(0,4)) the list of emails (aCell.offset(0,3)) (so only one email sent per email address) and a list of questions (aCell.offset(0,1)) based on a...

Hello, I'm trying to learn the Dictionary to speed up my Vlookup but it won't work. My case is very simple: I have Sheet 1 with names+ages and need to add the profession, found in Sheet 2: Sheet1 ===== Name|Age|Profession John|25| Marc|31| Susan|54| Karin|21| Sheet2 ===== Name|profession...

My code need more than one hours to complete for 3500 rows data but I need to work for more than 40000 rows data. I am looking for alternatives to my code by using dictionary, with improved performance within the context of interest. Could anyone help me? <code style="margin: 0px; padding...

I have 250 uniquely named shapes(dots) on a sheet named after cities. Most of my macros assigned to buttons perform two functions: hide/show individually listed dots and autofilters a range of data related to the dots. I would like the dots to react (hide/show) based on the results of...

Hi all, Thanks for all of the help previously. Here's a problem I'm having: I am using the .find method in a Do...While Loop to find duplicate values, but I want the loop to stop when it gets to the bottom of the range, not wrap around and search from the top (another way to put it would be...

Hi everyone, I'm trying to loop through all the cell in column B in sheet 2 to see if they match the key in the dictionary. If it does, then it should copy the row to sheet 1. This is what I currently have. I literally just started studying VBA last week. Sorry for the bad coding =p Dim...

Hi, I have the below snippet of code which is creating a unique list for a combobox on a form. It works very well to provide me the unique list of values from column "U," however I would like to include the associated Values from column "M." I have read through a number of posts on this topic...

I'm using a dictionary object with an item that contains an Array. In trying to set the value of array elements, it does not work. It simply stays with an Empty value. Any ideas? I don't seem to have problems setting the value of other non-array items in the dictionary. Sub test() Dim...

Hey, I have a macro that loops thorugh a list of supplier codes on a worksheet and checks each one to see if that number appears in a text file. The text file represents a subset of supplier codes based on location, and as such is frequently updated. Currently, I'm importing the data from the...