efficiency

I have a Database that looks like this: Before <tbody> [A].NAME, [A].GROUP_CODE, [A].ENTITLED_AMT, A].PTY_TRN_UID, [A].SumOfEntAmt Jim NAN -26.20 J301 -218.5 Jim NAN 26.20 J302 218.5 Jim NAN -75.20 J301 -218.5 Jim NAN 75.20 J302 218.5...

Hi, This is what I currently have : Google Drive: https://docs.google.com/file/d/0B89c...it?usp=sharing I currently have =sum() formula in the STARTING from the column range: EA101 --> =SUM(CA101:CA105) <<sum of="" 5="" rows="">></sum> Drag to autofill across, and to bottom, 4 rows above...

I have several tabs that break out specific data for different locations. </SPAN> I am creating another tab summarize the data. What I am wanting to know is it more efficient to subtotal the data on each location tab and then total the sub totals on the summary tab or is it better to total...

I currently have the following code to load all file names and paths into my workbook: For Each File In fld.Files DoEvents 'allow other processes to execute TotalFileCount = TotalFileCount + 1 'increment file counter...

I have a large spreadsheet with students' test scores since 2006. I wanted to find out how 10th graders who were in our system in our system since 4th grade did. Thus I want I subset of our group of 2012 10th grade students. The spreadsheet has student info and then grade, the date the test...

iRowL is generally over 2000. Waiting for this loop to execute is like watching paint drying. Any suggestions will be appreciated.

I have a macro that loops thousands of times, and I believe it is really being slowed down by several Vlookups occuring in the code. I have several large arrays with data, and I need to pull data from the array in each loop using a different lookup value. Currently I am using...

i've create a VBA code that uses Solver several times to optimize four values on my spreadsheet (the location of the four values does not change). The solver only requires calculations on a certain number of rows (say 1-200), but changing the four variables will recalculate the entire...

I thnk this should be easy but I did not find it in a quick look through the archives. I have an example where I want to find the state average (mean) but the way the state reports the data makes it more complicated. It does not tell me the state average but it does tell me the number of kids...

hi all, Im hoping that someone can help me improve the efficiency of the below code. It currently takes about 20-25 seconds to run, which would be acceptable if it only had to run once, but it has to run 10+ times, which is blowing the processing time out into minutes which is far to long. The...

Hi all, I'm hoping somebody out there can help me with this. I currently have a macro that loops through a series of cells and populates them off a table stored in another sheet. The segment of the current code is below: On Error Resume Next Dim lookup_val As String For x = 12 To 36...

Curious to know is there a way to run multiple macros at once...literally at the same time. For example, let's say I had a macro "A" which works well but takes three hours to complete... I'm wondering if I open three sessions of MS Excel and run macro "A1", "A2", and "A3" if I can cut down the...

I'm trying to make sure that a huge range of IF statements evaluate as quickly and efficiently as possible. Each cell that I'm testing has either a number or a "-" if there is no data. On the presentation sheet, I want to show a blank cell when there is no data. So, the IF statements all say...

Quick question here: If I want to copy a cell (say... the input sheet, cell C4) and paste only its value somewhere else (say... the results sheet, cell B4), is there a better way to do it than [C4].Copy Sheets("Results").Range("B4").PasteSpecial Paste:=xlPasteValues, Operation:= _...

I'm working on creating a table that dynamically adjusts its appearance based on what data the user inputs. Eventually, this table will be used to feed an existing spreadsheet with data to generate an entire new spreadsheet worth of results. The way it works now is that there are several...