arrays and loop

I have an exported file, basically an Excel text spreadsheet with column headers and around 2000 lines. It can change, so I don't have a fixed array size. I have stumbled through things where I believe I can build the array, but get lost on essentially how to call out and display specific parts...

VBA newbie here. I'm starting with a single workbook that has 2 sheets. With this, I'm trying to figure out code that would accomplish the following on execution: Create an Array with n elements, where n is the number of Unique Strings found within the Cells in Column B (excluding B1 and...

Hi all, I'm hoping someone can help with an issue I have. I want to change how I merge multiple arrays using a unique ID. I was initially able to do this via a solution I saw on this board ( VBA Macro - Merge Worksheets Columns using Unique ID ) which initially worked. However, my data has...

I have a spreadsheet where i create 4-5 fairly large matrices in worksheet cells and then perform some further calculation using these. I'd like to update the spreadsheet to not use worksheet cells and to hopefully run faster. I've started to do this using 2D Arrays to store my data in...

Hi everyone, Hopefully this is a pretty simple fix, as I'm just beginning to become familiar with arrays in VBA. I'm looking to fill an array with the cell addresses using a For loop. I'm wondering if the problem is occurring because the arrays are by default Variant (?). Thanks for your help...

I'm trying to find an easier way to approach this task. I currently have a method that works but I'm trying to simplify things for editing. We have a Team of Employees TA = Split(employeenames,",") I want to create a report exclusively for them. I have a way of filtering them out but it's...

Hello all, I have a problem with the following: I have multiple columns of numbers, which are sorted in ascending order and can be of variable length and interval, but always start at 0. For this problem, I have selected 4 columns though. <tbody> 0.00 0.00 0.00 0.00 0.25 0.3025 0.1600...

I'm in the process of setting up a model based on a simple p&L centre. The idea is to model out one centre (something like a franchise store) and each time we open another store it starts at the beginning of the model. I could do a cascade (as illustrated below) but that is not very elegant...

Hi, I have an excel worksheet which has 30-35 pages/page breaks. There are in all 4 sections spread across these pages. what i want to do here is insert a particular shape ("water_1") on only two of sections from the page section starts and ends. Below is the array code followed by loop which...

Hi, let me explain what im trying to achieve: -We have a list of people identified by ID, in Worksheet #1 there are no duplicate IDs however we have several trainings related to that ID (123 has Excel, PPT and Word), in Worksheet #2 its a separate report in where the ID is duplicated because...

Hi Excel Gurus, I need help with a small VBA logic that can loop through a set of tasks and assign Employees to the tasks. Process: I have a set of tasks (Task 1 to Task 10) I have 3 Employees (John, Ken and Kyle). Everyday I allocate different % of tasks for each employee based on their work...