dictionaries

  1. D

    vba extract data from text file

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

    VBA Recipe calculator sum the ingredients

    Hello, I need a piece of code that will calculate the quantities of needed ingredients for some products but i am stuck with some 2d arrays and the code messed up. Can you please help me? In the attached images, -the result for ingredient1 is 40 because we need 20 cakes and we use 2 pcs in...
  3. szita2000

    Excel VBA copy-find-paste. Use of collections or Dictionaries?

    Hi All. Hope you all safe and good in these Covid times. I have a task ahead of me and I am thinking that maybe there is a better way to code this. I have two workbooks. Source and target. I need to pull out values from the source and paste it to the target, It is not a block per say, but...
  4. DataBlake

    Personal Workbook Macro Punlic Dictionary Set Up [vba]

    I want to create some dictionaries that i can access in any workbook. I.E a list of colors as the key and a list of shortened versions of that color. Gloss Black White Trim = key Black = Value i have a sheet with these values that i would like to establish as a disctionary A: will this work if...
  5. Nelson78

    Dictionaries and vba: when to use

    Hello everybody. I've been studying some of the solutions found in mrexcel.com about dictionaries. Having applied them "blindly" to my issues with success, I've decided to understand better their dynamic. Suppose I've a table like this: https://imgur.com/h2sfGql How can I build a dictionaries...
  6. R

    Comparing data in 2 text files

    I have written a piece of code that asks the user to open one text file and it loads it into an Excel sheet. Then asks for a second text file which it loads into another sheet. Then runs through the second sheet to find corresponding records and when it does it compares a column of data. This...
    • Ronanm
    • Thread
    • compare comparing data dictionaries maximum rows text file import
    • Replies: 1
    • Forum: Excel Questions
  7. Manuel Cavero

    How to calculate the Correlation of multiple Dictionaries?

    Hello everyone: I have some dictionaries with values, and I need to calculate the correlation between the values of dictionaries. Let's see the code: Sub Test() Dim Dic1 as New Scripting.Dictionary Dim Dic2 as New Scripting.Dictionary Dim Dic3 as New Scripting.Dictionary Dim Dictionaries as...

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
Back
Top