array

Hello dear, I have data in a2:f5, a1:f1 is header row. a2:c5 contain the details like style, order & color d2:f5 contain the quantity. I would like to perform the calculation on d2:f5. d2:f5 each cell will divided by 30, like 100/30=3.333 so for d2 it will be 100/30=3.3333, in d2 cell value...

Hi all, I have inventory stock details with 11,000 part count and I am making vehicle from this inventory. Now for one vehicle I require 1300 to 1500 parts with varying quantity on each part. there will be multiple vehicle codes I want to create a crisp VBA where it will show me 1) how many...

I have code I am developing where source data exists from column A to L starting at row 7. Separately, an output field based on that data exists in column M. Goals of Code: 1) Import all data into an Array named "DataSet" 2) If any data exists in column M: 2a) Delete all data including...

I'm using this to create an array of numbers. The example array is shown below. Instead of entering {1,2,3,4,5,6,7,8,9,10,100,2000} ... wanted to input something like "1-10,100,2000". Is this possible? Sub arr_from_input() Dim arr_num As Variant Dim i As Long arr_num =...

I want to return a list of headers in column R wherever there is a value match in column N. Column n contains extracted phone numbers, which I use as ID's Where TRUE exists in any row of a column AB to AK, that header (AB1 .. AK1)) is returned plus a line break, for each of columns AB:AK...

Hello Everyone, When I click a button on a sheet within my workbook, I want a macro to do the following: Copy all the sheets named in cell “AA1” to a new workbook (I’m having trouble getting a dynamic array to work for this). If the array needs each sheet name in a different cell, I can put...

Hi, In my code I created a custom array of a raw data sheet (temp) with about 50 columns. My targetsheet where I want to paste this data has only around 15 columns and not all the columns in the targetsheet are in the raw data sheet. I only want to paste the values from my array in the...

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