dynamic array

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

Hi all, In Excel 2010, Windows 7, I've created a macro for a pivot table with a dynamic array as source data. I created the array by naming a table with the formula =OFFSET(a1,0,0,COUNTA(a:a),3), so that I could always incorporate new rows of data into the macro each time I run it. The problem...

I am not great with excel macros, so what I think I need is a dynamic array. I have created a function that assigns the color of a cell to a number, and I need to store that number somewhere so that I can sort by it later. The number of cells with colors that need to be assigned a number and...

I have a sumproduct formula below on a summary sheet in a workbook which works fine. I have multiple tabs in the workbook. Is there a way i can reference each tab based on a cell and copy this formula over based on the tab name? =SUMPRODUCT((Burt!B4:G4='Overall...

My issue is with a number of tasks all written in one macro, but one task refers to a dynamic range that the macro needs to copy and past elsewhere in the workbook, but on occasion that dynamic range won't have any data and therefore equal to no range to copy so the code gets stuck, how do I get...

Hey everyone, I have what should be a fairly simple problem that has been taking me forever to figure out. Here is my situation (Using Excel 07): I'm going to be inputting 100 numbers into a column (Say B2:B101) and need to make a histogram out of that at intervals of 1 from the lower bound to...