vba dictionary

  1. S

    Custom VBA Dictionary Solution

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

    PROBLEM SUMIF ARRAY IN RESULT

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

    LOOKUP IN VBA ARRAY AND DICTIONARY

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

    vlookup dictionary approximate match

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

    SUMIF VBA ARRAY & DICTIONARY

    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"...
  6. R

    Want To Change Formula To Vba Array & Dictionary

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

    PROBLEM VBA DICTIONARY

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

    import image filename with vba array & dictionary

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

    Dictionary in VBA

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top