dictionaries

Hello people with a greater mind than my own. I'm in need of serious help. I have an excel data structure: Path_a1 Field_1 1 Path_a1 Field_2 2 Path_a2[1] Field_1 3 Path_a2[1] Field_2 4 Path_a2[2] Field_1 5 Path_a2[2] Field_2 6 Path_a2[2] Path_b2[1] Field_1 7...

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

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

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

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

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

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

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