array 2 variables

Dear all, I have the below code which uses Dictonary object [CreateObject("Scripting.Dictionary")] to get the unique string name and number of occurrence of the specific string. [ Sub CountUniqueStrings() Dim lastRow As Long Dim dict As Object Dim cell As Range Dim...

Hi! I've been trying to use Excel formulas (No VBA) to mimic the behavior of nested "for" loops. I want to create a table of calculated values, where the values are determined by filtering on the column label and row label. The row labels and column labels are derived using unique() on columns...

I have a database with different types of membership types in row 1; they do repeat depending on the member. There is actually 200 members with a total of 10 different types. In column 1 I have what they spent money on; again they do repeat. There is actually 15 different spending categories...

Hi everyone- I have a worksheet ("IMPORT") that I want to show / hide columns based on selections from another worksheet ("~SETTINGS"). The worksheet ("~SETTINGS") has a table with the column names from the "IMPORT" sheet in the first column, and a "TRUE" or "FALSE" value in the second...

I have a report that I need to update from the data in another report. Both reports are large, over 50,000 rows, so I read them into arrays so the process would run faster. I need to split the Source array into separate arrays based on certain conditions in the HR array. I'm getting an object...

Hello Below is a sample of the data file I'm working with. I'm not sure what will be shown here as I haven't used xl2BB, so I hope I'm doing this right. It should run from column 'A1 - H4' with column 'H' being blank at the moment. H6 That didn't seem to show all the data so I'll try once...

Hi, I am building a tool that contains a list of worksheets that the user can choose to either "Exclude" or resequence in their preferred order. I am hoping to learn how this can be achieved using arrays and have so far developed the following: Sub test_001() Dim IndexCell As Range Dim...

I have the following sheet https://1drv.ms/x/s!Ai6fM6lT5gt6h0vP6kgG5MmfsdsU It consists of a table that is populated by a list (with an array). The last column of the table is based on a value in B21. Goal: I want to populate a second table based on the value in B21 and based on the last...