array

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

Hi, I am looking for one Excel formula to put in cell A1 that counts all AD values on workdays (not weekends nor holiday 2-01) from the beginning to the end of the month. The dates (see image) are in row 2, the values in row 3. I am struggling with this.

Hello and thanks for reading. I am missing something simple here on a conditional loop. I am first checking to see if a textbox on a userform has a number in it. If it does not, i am looping through the 5 sheets that may have the number in cell P14. Whenever i find the number i want to change...

Can anyone help me with the following? I have a spreadsheet containing data having IP addresses in which I need to create a output text file. A sample input file would look like this owner active group address exp a 1 gray 10.10.10.10 1/1/2023 b 1 blue 10.10.10.12-10.10.10.15 1/1/2023...

I have a 2D-Array and I want to look up for values in the column. arrDestination(0, i) = Name(i) (asdfg, csda, asdfg,zzz) arrDestination(1, i) = Values(i) (100, 50, 100, 60) My 2D Arrays contains the names and values. If my arrDestination Array match with Column A then I want to insert the...

Hello, i am trying to run a macro that print an array of sheets in the description. However i have a macro that hides certain sheets pending other options and when i do the printout option it comes up with an error if one of the ****s has been hidden. The sheets need to remain hidden depending...

Hi, I am trying to generate headers for a table. I decided to create a function just to generate header for my table. and to decide which row the header will go to my idea is to put the first element of my array(array that will be pass into the function)as the row number. following is my...

Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...

How can I open file1 from list1, copy sheet1 from file1, paste it on sheetname1 from list2, close file1 and go to the next.... for any amount of files, variable until the named range is done. Sheets("Data").Range("E2:E30") is list1, list of files {C:\Documents\robertheinz.xlsx...

Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks

Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...

I am working on putting a template together for my company and ran into a problem with having two dropdown lists. The goal is to have that ever is selected in list 1 to populate only a set list of items for list 2. The spreadsheet attached i am working in column 'H' & 'I'. the code form column...

Hello all - I have a question, please: Col A has values. Col B checks a condition and returns true or not ("Y"). If Col B returns TRUE, Col C stores Col A's value. Col D repeats the stored value so that: Col E can check Col D against a different condition, and returns TRUE or not. This...

Hi, I'm trying to do a formula to show the totals of each group based on different criteria that could possibly change. For example, with the below data I'd want in a separate spreadsheet showing the two subtotals (342.88, 138.28 etc) but these subtotals are based on column B(4141, 4142 etc)...