array

Hey, I basically have 2 sheets lets call them Data sheet and Destination sheet. Data sheet has around 30 columns and Destination sheet has around 15 columns. I want to populate the 15 columns if they match any of the headers from the data sheet file and if column 3 in the datasheet file is 0 I...

Hi folks. I have some working code here but it is very slow. Could anyone suggest a faster alternative? I did try using the dictionary but eventually gave up. It was the passing of the dictionary to and from the sub while also passing the sheet name that was causing the problems. I think perhaps...

I have inaccurate results being returned from the Min( ) and Max( ) functions when used in VBA script. If the value being returned from the array is a whole number, these functions are returning the correct value. If not a whole number, then these functions are returning the correct-ish value...

I have the code below, written by someone else and face an issue we have not seen before. ReDim b(1 To UBound(a) * UBound(a, 2), 1 To 5) For i = 2 To UBound(a, 1) ant = a(i, 2) ini = 0.01 For j = 2 To UBound(a, 2) If ant <> a(i, j) Then If ant <>...

Hello, guys, I want some help with my excel functions (Sorry I don't speak English so my post will likely be a challenge to read) Here's the sheet (sheet 2) : the function(on the Left): 3/10/2023 3/11/2023 3/12/2023 3/13/2023 3/14/2023 3/15/2023 ABC...

Hello This should be a simple problem but I'm not familiar with arrays. So please bear with me for a couple of minutes. Let's take MyArray = ("John", "Jessica" , "Walter", "" , "Peter", "Jack", "Mary") , just to spread those names over [A1:G1] with a minimum of code. I suppose an array is the...

Hey I just wanted to know if its possible to copy ROW Colors from sheet 2 into sheet 1 by a condition. The condition Would be the value coloumn A on each row is the same on as on sheet 1. For example Sheet 2 Table Johannes (This row has the color red) A Peter (This row has the color...

Hiya, I'm building a roster for my business and to save time, I'm attempting to automate it. this is due to multiple rosters rebuilds taking place throughout the rostered period & I would rather not copy and paste names hundreds of times. The Roster on Sheet "Roster" looks like this...

I need to find certain columns based on header name in 1 sheet and copy them to another. My code works for "Task Type" and "User". However it does not copy the other columns. I tried using 2 words and it worked. For ex. Instead of "User Email Address", I changed the column header and array to...

Good Afternoon, I'm trying to assign values (whole number > 0 but <= 5) to each side of a four-sided polygon (sides a, b, c, d) in which the values add up to the same total, such as 12. However, the polygon must be unique regardless of orientation. One way I was visualizing this using Excel...

I have a formula that lists several cells to look for the letter X. If X is in any single cell a text is displayed "Package Price" in K25. Need formula to be converted from strings of cells to arrays. Current formula: If(OR(E41=”X”,E42=”X”,E43=”X”,),”Package Price”,””) Need new formula to make...

Hello everyone I hav somee code which shold work but it is returning an error code 9 and I have no idea why. It's supposed to loop through a range of cells with strings that look like this: "AM17, 12: ;HM2; AM40; AM45, 13". I'm sure the code works but I don't understand how to solve this error...

Hi I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates. The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...

Hi I've been looking at a lot of transpose demos, still can't get what I need to do this so let me explain. I have a four column table and I am looking to Transpose it over to a two column table or array? It will reuse the column headers so I'm thinking a loop for them and a counter to...

What would be the FORMULA to list the numbers between the value of a cell and 1? Basically finding all whole numbers between 1 and the value of the cell. Example (Source) A1 = 4 (Result) B1 = 1 / B2 = 2 / B3 = 3 / B4 = 4 / etc. Purpose, I want to enter a number into a cell (A1), and create a...

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

Hi I have a reference cell B2 which contains the year. I would like to create a formula that contains dates (not referenced in cells) and counts the duplicate dates. Within the formula I have the fixed dates DATE(YEAR(B2),1,1),DATE(YEAR(B2),3,2),DATE(YEAR(B2),5,1),DATE(YEAR(B2),5,9) and I would...

I am working with arrays now and the IF statement is judging wrong. I resumed my code: Sub Reset() Nr=6 Dim X, Y, MinX, AM, NX, W As Double Y=200,00 AM=5,00 ReDim X(Nr) ReDim Z(Nr) For i = 1 To NrParcelas X(i - 1) = Y - WorksheetFunction.Sum(.Range(.Cells(2, LTi.Column + i - 1)...

Hi, I am building a VBA macro that will run VLOOKUP on user input with the following functionality: 1. Takes in user typed or pasted data from sheet "Main" 2. Ports the data from sheet "Main" to an array. 3. Array processing: Common invisible characters are removed, data is trimmed, data...

I have a list of zip codes in a verticle column (A32:A200) on a sheet Named "Formulas". I have an image named "Bolt" in cell C4 on a sheet, named "New Job Log". Also on that New Job Log sheet, I have two non adjacent columns. On the left, starting at C5 is an empty column of cells. On the...