faster

I KNOW there's an easier way to do this.... Thanks in advance for looking! Goal: I only want the sub-totals of each CATEGORY in the Income Statement as well as the Total Income. I have an Income Statement I'm reviewing that's 220 lines long. There is currently NO grouping. Below is an...

:confused:Hi everyone, i made a VBA code and its taking to much time ..may you please make it faster this code i have 100000 rows and 11 columns x = 3 Do Until Sheets("Tracker").Range("B" & x).Value = "" Sheets("Tracker").Range("L" & x).Value = Application.WorksheetFunction.CountIfs _...

Hello, I have a very large spreadsheet with many tabs with links to different workbooks. The only thing I have to change is the 2017 to 2018 in the links. What would be faster, edit/replace or updating links?

I have a spreadsheet which has many +COUNTIFS, +SUMIFs in a series. Example =COUNTIFS(A1:A100,"*Name*",B1:100,"*Title*")+COUNTIFS(A1:A100,"*Other*",B1:100,"*Other*")+COUNTIFS(A1:A100,"*Var1*",B1:100,"*Var2*")+ If I redo with something like this below, would this improve excel's ability to...

I'm doing a massive number of Vlookups on an old computer running the latest version of Excel . I've heard both that index/match is faster, and that it used to be, but isn't much anymore. Some vlookups are only in one column, some will be a few columns wide. I'm more comfortable with vlookup...

Greetings, I have the following code which is REALLY For Each pi In pt.DataPivotField.PivotItems pi.Caption = Pi.Caption & " " Next pi How do I make this faster? Is there something that I am missing here? Thanks,

Right now I have lots of cells in my table that use the NOW function, which is volatile. Would it be faster to just have one cell outside of my table that would store the value of NOW and then have all the other cells reference that cell address in their calculations, or would that be a waste of...

I have the following question with this working VBA code and would appreciate some help (if at all possible) to make the code faster. Especially when clearing up to 50 cells. The shown VBA code is copying the last row of a table and inserts it below. Some cells are cleared from its contents. The...

hello, i have a an excel file with lot of sheet's and formulas when i add data it make calculation slower :( and i have "Calculating: (4 Processor(s)): %" at the bottom right of the workbook? if i opened this excel file on another computer with higher model and faster should the the excel...

All I'm trying to achieve here is to look at 2 data extracts (this weeks against last weeks) and highlight any deltas... SO, what is on this weeks file that wasn't on last weeks - As they'll need creating/loading and, what's on last weeks file that isn't on this weeks - As they'll need...

I have a very long code that does exactly what I need it to do, except it takes 25 seconds to run. I have narrowed it down to the following two sections of code that are slowing it down. Can anyone help me on how to make these run faster? First Section: lastrow = Sheets("Crew...

My code need more than one hours to complete for 3500 rows data but I need to work for more than 40000 rows data. I am looking for alternatives to my code by using dictionary, with improved performance within the context of interest. Could anyone help me? <code style="margin: 0px; padding...

Hi mr excel. I select data and Series on ROw 2 for chart 1. So when I create chart 2 I copy paste chart 1 and change series on ROW 3. so the problem is i have 1000 rows data. and it waste time when using my way. is there any way faster?

Hi, I couldnt find in the internet a loop that returns a multiple selection. Private X0, Y0, Lx, Ly, Atotal As Integer 'X0 = Position of the first cell in the first machine on Monday 'X0 = Position of the first cell in the first machine on Monday 'Lx = Widht, in cells...

Can anyone help with the following, i did post earlier but it was on another subject. I have the following code: Sheets("MCA CODES").Select Range("D1").Select Do ActiveCell.FormulaR1C1 = "=MID(RC[-1],5,3)" ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 =...

I've tried the trick of removing any duplicate or corrupted fonts. Are there any other steps I can take to make Excel 2011 for Mac launch faster? I recall there used to be an "Office Helper" or some program that was set to launch on computer startup and run in the background, but that was years...

I'm looking to make my vba code run faster. Any suggestions? Sub ShadeAllSw() Application.EnableEvents = False Application.ScreenUpdating = False Application.Calculation = xlCalculationManual ActiveSheet.DisplayPageBreaks = False ActiveSheet.ChartObjects("Chart 3").Activate Dim DrObj Dim Pict...

Hi! I'm using excel 2003 english version in windows 7. I have a paperform where we take notes of different things through a period. My wish is to have the same information saved on a spreadsheet, so it would be easy to search through for information and print out a new updated paperform if we...

Can anyone help me speed up this code? It takes way too long to run Dim file As Integer, x As Integer, rw As Integer, cl As Integer Dim fl As String Dim count As Integer Cells(1, 37).Select fl = Dir("C:\(Path)" & "*.xls") Do While Len(fl) > 0...