dictionary

Hello, I am currently working on a set of two classes: one being a custom object model, and the latter a custom Dictionary class, with my 1st class as key, and the items being arraylists. I am facing a problem for which i am completely aware and kinda anticipated. It is explained here in...

Hi, I have been battling to understand why an array is not being updated where the array is in place of a key/value pair. I have the following in VBA: Dim testDict As Object Dim testKey As String Dim arr(1) As Double Set testDict = CreateObject("Scripting.Dictionary") testKey = "TestKey" arr(0)...

Hi folks. I have some working code here but it is very slow. Could anyone suggest a faster alternative? I did try using the dictionary but eventually gave up. It was the passing of the dictionary to and from the sub while also passing the sheet name that was causing the problems. I think perhaps...

To all As part of macro (to post process data), I am exploring the ideas of getting rid of a vlookup() creation by something that could potentially be more flexible (long term) With the following data held in 1 tab What would be the best way of creating a dictionary which would look like...

Hi, Long time lurker, first time poster and VBA newb so bear with me. I am looking for a way to automate some reports that are currently done manually. Sheet1 contains a list of WO numbers in Column C. Sheet2 contains a list of potential matching WO numbers in Column A. Looking to take the WO...

Hi, I would like to create a macro that will filter the data, but the problem is, I don't know exactly what the data will be in the file. For this purpose, I used a dictionary that goes through a given column and saves the keys that I want to filter later. Unfortunately, I don't know how to get...

Hi, I've got two workbooks ExtOrgsList.xlsx contains an ID of a Customer. The ID is in Column A and the Customer name is in Column B. Destination.csv has column AN which contains the Customer names. The code below works but if there's any deviation in the name it returns the partial match...

Hello, I am seeing two different things with dictionaries and was wondering what is the difference between the two and the benefit of using one over the other. I am seeing Dim dict as new dictionary and Dim dict as scripting.dictionary what is the difference between new dictionary and...

Hello, I am wondering if there is a way to select a text file and loop through the text file line by line. each line is similar to this structure "FORM 1","1","0","0","NAME","Diego","O" "FORM 1","2","0","0","NAME","Pedro","O" etc. . . and put it into a dictionary of sorts to store the...

Using this code below gives me a result of a unique customer codes base on Calculation sheet. However, I want to get my result base on the list that I have in Solution Sheet. Also want to run the macro in button inside Solution sheet. Any help will be appreciated. Calculation Sheet Solution...

I'm trying to use dictionary for 3 different columns with COUNTIF and SUMIF getting the value from another sheet. I'm having a hard time getting the right code to get the value from another sheet, below is my currently using code. Any help will do thanks. Transact Sheet Invoice Sheet Sub...

I am trying to build a multi value dictionary from a sheet of data that has 4 different columns of data, where the first column would be the key and the 3 next columns would be the items I keep getting a compile error: Method or Data member not found. Please help

Hi just checking If anybody can help be with this as I have a long way to go I have a simple VBA code that lets you import data from another workbook into active workbook by using the file open dialog. currently the code just clears the sheet and imports all the data into active workbook. I...

Dear All master, I want to make transpose with vba code dictionary and array because the number of rows or records is 10,000. The sheet name is "MASTER" and is it possible to directly transpose on the same sheet and create a table directly? this is original data...

Hello, I was told to collect before worrying about printing and doing so using a dictionary and a unique key The unique key is something in the outer dictionary is what i was told too But i am not sure what that means, or the creation of a dictionary. i am new to VBA and trying to create...

Hi everyone, I'm migrating data from a legacy source information system to a new information system and want to confirm a variety of counts of values from the source data against the counts of the same values from the migrated data to ensure the counts match as a way to verify the records...

I want to use vba dictionary method to calculate over 100k rows instead of in worksheet countif function to reduce time of calculation but I could not find how to convert my formula which shown in below. Range("AG2").Formula = "=COUNTIF($AF$2:$AF100000,"YES" & X2 & Z2 & "TRUE")"...

Hi, First time posting a thread, long time user/reader of threads. I need help solving a problem that I can't find the answer (or close to the answer) to. What I want to do: Given a table of data which includes Part number, quote date, quantity, price and supplier, I want iterate through the...

i have the following excel sheet and need to reformat the data from a vertical view to a horizontal one while lining up the data in the appropriate columns. the vertical column is labeled Key and Value ("A:B") the reformatted output is labeled to the right called Key, followed up by the keys...

Sub findQTY() Dim pnum As Variant pnum = InputBox("Please Type in the part number") If dicQTY.exists(pnum) Then MsgBox dicQTY(pnum) Else MsgBox "No quantity available for this part number" End If End Sub the objective is to have the user enter a part number and it will either return the...