dynamic array

Hi, I am trying to create a dynamic table that extracts records that fall between a certain date range. I am unable to get the list to populate. My formula is as Follows: {=IF(ROWS(L$9:L9<=$M$2,INDEX(INDIRECT(L$8),SMALL(IF(Add_time>=$C$3,IF(Add_time<=$D$3...

Hi everyone, I am trying to set up a logic to identify the trends that should be copied into a different workbook. So far, I can identify where the trend is, but I am not able to set up the range, probably due to a variable definition. My attempt is to find the name I want (cll1) in w/s...

Dear All, After a lot of effort (I am a brand new in VBA) I have managed to create a macro to do the following: 1. Copy time vs. Volume data (with variable lengths). A18:B18 2. Calculate deltaT and deltaVolume. (A19:B19). 3. For a constant DR located in cell C6 in the same w/s the following is...

All, Hoping someone can help me out here. Here's my need. What follows is a simplified explanation of my spreadsheet. I have two sheets ASSIGNMENTS and AVAILABLE CAPACITY The ASSIGNMENTS sheet has a list of staff members assigned to every project we are working on. There are as many rows...

Hello everyone, i'm new to the group posting, but not new reading all the great solutions. I've been working on this insertion of data for while now and cannot get it. In the past i've created a bunch of do and if then's to make it work, but it was not an array and it literally took over an hr...

Hi everyone, I have been struggiling with this for a couple days now and I am *this* close but then the solution eludes me. I have two spreadsheets with two columns each (there are more columns but only two are used at the moment): Spreadsheet 1 (sample): <tbody> e-mail address timestamp...

I'm trying to make a dynamic form that will show QTY and Sales sums for current Week, MTD, YTD, and QTD. On the form I have week set up and working already with the formula =SUMIF('Raw Data'!$H:$H,$B$1&$B$2&$A$3&$A9&$C$1,'Raw Data'!$G:$G) Where as B1 & B2 are the year and month (Value will...

Hello All, I am using Excel 2010. I named a data set System and on another spread sheet I have a column for the name of the data sets. I want to write a vlookup and use the column with the names of the data set, lets use B2, as the array. For example: =vlookup($A2,B2,18,false) I also...

hello all, I am dealing with two arrays. first one is called aTbl and it part of wider procedure 'For Each ...' checking whether selected items meet various criteria of the items or not. aTbl remembers the row number of correct items (rKom.Row). nTbl = nTbl + 1 If nTbl = 1 Then...

Have a spreadsheet with two columns. Parse data, both the # & letters; then output onto bucketed i.e. 1-100 tab w/corresponding letter/ <tbody> 7.259764189 a 271.7909785 b 69.12924367 c ... ... </tbody> Writing VBA code (even though this could be done manually) so that the numbers are...

So I am once again perplexed. From my data i create a pivot table. From that pivot table i "show report filter pages". On each of those pages i copy 2 of the columns and place them adjoining the new PT's. One is a % number and one is in currency. I then select the PT and the 2 new columns and...

Hi, I am hoping to use Data Validation to create a drop-down list from a dynamic column that contains a mix of text cells and number cells. To make it more complicated, the list needs basically every convenience feature known to man (or that I can think of): it needs to be dynamic...

hello, I have a column with data that I work with (let's call it A). Based on A I get data from AS400 PCCOM IBM emulator (let's call it B). What I need to check on is whether B data is unique or not. If B is a duplicate, then I need to check whether C column (value known from the beginning)...

Hi, I'm trying to make an array formula with vba where the logical test stops at the last row. I'm hoping this will speed up the macro instead of scanning a whole column C:C for example, which could have 2,000 - 600,000+ rows. Sheet 1 has the data Sheet 4 is where im putting the fomula I was...

Hi folks, I did look at the other threads about this but couldn't find an answer within. My situation is as follows. I have a sheet that generates a list of file names to be imported into different sheets, I'm writing code to loop through the sheets and import them all into each (each list of...

Hi Guys, Can you create a dynamic array from cell values please? Below is an example of my cost centers per manager, stored on the first tab (about 50 managers) so I would like to loop through and create an array to group the sheets, each cost center is in a separate cell. Then create a new...

I have a large range of automatically generated columns that report daily predicted inventory levels going off into the future about a year so that's 360+ columns of data. These numbers can be positive, negative, or 0. Given a user supplied integer "N" I need to find the StartDate of the Nth...

Friends, I have the below mentioned data in the excel workbook "Sheet1" A1:A10 - CG,CG,CG,EXV,EXV,EMB,EMB,EMB,GSB,GSB B1:B10: DOZ, JCB, GRD, TP, VCOM, GRD, TP, GRD, COMP, TP Now in Sheet 2 in different worksheet, I have this data C1:C10 : EXV,EXV,GSB,GSB,CG,CG,Cg,EMB,EMB,EMB Now, by using...

I am trying to write code that will find a dynamic array of sheets in a workbook and collect those to print, starting with Sheet(5) and finding all sheets after that. The number of sheets will change for each client depending on the number of salesmen for each. Any help you can give will be...

I have a listbox on a form set as MultiSelect and I want to put the rows that were selected in an array. Consider this code: Dim chkBoxArr() as long Dim icount, j as integer For j = 1 To Userform1.Listbox1.ListCount - 1 If UserForm1.ListBox1.Selected(j) Then chkBoxArr(icount) =...