vba dictionary

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...

Searching for a custom VBA dictionary code, for a massive workbook, containing two worksheets, sheet1 (Release) containing +40K rows, sheet 2 (Resource) containing +185k rows. I realize that any VBA macro will take a long time to execute this command–given the amount of data, that’s okay with me...

Dear All Master, It should be in column B in the "recon" sheet which I mark yellow but I use the vba code below but the result is in column G in the sheet "recon" which I mark red. There may be something wrong in the code I edited below and I just added a little or modified it a little without...

Dear All Master, I want the formula in the T & U column to be a vba array and dictonary code so that it becomes faster and please also add a comment matrix in the code so it's easy to understand. Thanks roykana DESIRED RESULT ABCDEFGHIJKLMNOPQRSTU1No TransactionDateDept.Code Pel.Name...

Dear all Master, below I want the desired result in column E which I marked in yellow and also I use a formula so it's easy to understand what I mean and I want to add a little in the code below without changing the structure of the code below and I also made a vba code for in column E in sheet...

Dear all master, I want a fast code sumif vba array and dictionary because there are three hundred thousand records. I've also made the sumif vba array and dictionary code but it only works for 1 column and 1 criteria results. Please help for the solution. sheet name "OPS" with table name "OPS"...

Dear All Master, I want to change the formula to vba array and dictionary because there are 350000 records and I also use add custom columns in power query so excel formulas don't run automatically so my solution is to use vba. for information my sheet name is "GSG" and my table name is...

Dear all master, please help for the problem in the VBA dictionary does not appear because the source is text and the result is a number which I marked in yellow and the other results appear because the source is text Sub Demo0301() Dim Rng As Range, Ds As Range, n As Long, Dic As Object...

Dear All master, With this, my vba code to import image filenames with an open dialog box can import filenames from folders or subfolders to my excel table. For the id column, what I mean is before the "-" & "(" sign, then it is included in the id column. For filename originating from that...

Hi, I'm using the dictionary in VBA to summarize based on the units held in one column, but I would also like the code to summarize by amount, which is in another column, can I do this in the same sub and output both the results by name for units and amount. I have pasted the example how the...