speed

If I have query (1) with multiple steps and I need to have query (2) based on query (1). For performance and/or good practice is it better to: A) duplicate it and then modify and or remove the steps carried over to get what I need or B) is it better to reference it and then create steps to...

I have a worksheet (Sheet1) with thousands of rows, 150 columns and most cells have formulas. Formulas reference another worksheet (Sheet2) for input. When I try to add a row for example in Sheet2, Excel freezes for up to 10 minutes until cells are updated I presume. Looked at reasons why from...

I'm trying to find real estate listings that match a certain criteria and output the desired listings that match those criteria. My code works start to finish but an intermediate step takes 20+ minutes if the listings are >3000 or more. My goal is to do it with 40,000 or more listings. My...

I need a formula to calculate speed in kmph, given meters and seconds, for example i want to calculate the speed of a person who runs 100 meters in 12 seconds, the formula =A2/(D2*24) does not calculate it right, Thank you in advance.

Hi, Something strange when using Queries: I found a huge speed difference between these 2 situations : Situation1: - I make a first query "query1" and I do not load the result on a worksheet1 - I make a second query "query2" which call the "query1" by basically Source1 = query1 and do some...

My VBA code currently loops for 5,000 iterations and takes about 25 minutes to collect the output data in the Output excel sheet. Is there a way to reduce the time taken for instance by improving the copying and pasting of values, collecting the output data in some kind of array etc.? Given that...

Which is faster? I have two workbooks. One has all the personnel information and the other has equipment information. They team up to create picking sheets for the warehouse. Each provides information to the other one via vlookups. I was wondering if instead of doing a vlookup I could simply...

Anyone with experience using APIs or this one specifically. I have 92K locations stored with Easting / Northing. The API suggests that it has Road Speed for a large proportion of the road network (UK) and I'd like to use a formula or script to import this data against known location data. I can...

Can anyone help please, I have just added a picture vlookup into by spreadsheet that has now made the spreadsheet run so slow, some times I am waiting up to 15 seconds to move the cursor around the spread sheet. I have in 2 of my 20 or so VBA codes added the following, which did help speed it...

Hi, 2nd Post today but final configured this Macro to work how I want, but seems very slow and clunky, possibly the show all data lines? Can anyone help in speeding this up? Thanks.

Afternoon, Hope someone can decipher this code because I've looked and looked at it and it is WAY beyond my capabilities. I was kindly given the spreadsheet by another organiser but would like to refine it slightly. It's for a time trial. Basically, the event distance is entered at the top...

Can I add a line at the beginning of my Macro to set the row limit to 5000 (or whatever)? The Macro currently adjusts for "infinite" rows and I'm hoping this will speed it up. Thanks!

I have an issue with a Gantt Chart Template that I created, its very slow for some reason (I cant find the root cause :warning:) Could you please take a look of it and support me to speed it up? Thanks a lot!!! Download Link: https://drive.google.com/open?id=1nU...nDEKAB0iePAH6a

Hi, I have a 60MB workbook that takes 8+ minutes to open on my quad core laptop. It opens only using a single core (20%cpu). After the workbook opens the first few adjustments I make causes the Excel to hang and takes a few seconds (3-5) to respond. After I save the initial edits it's faster...

I am using this code which works fine, but runs painfully slow. What my code does is that it filters an Excel Table and then extracts only certain columns and pastes them into another sheet (in a different order). Could it be speed up perhaps with a multi-dimensional array instead of copying...

Is there anyway to speed up how Im doing this? I have more code like this but only posted a portion of it. Takes about 5 seconds to run the macro, would really like to lower that time. ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate ActiveCell.Value = B1...

Hi All, I’m sure there is an easier way to do this. I wish to compare multiple cells (not in a range) to a single criteria, i.e. having data in every second column (from B) compared to criteria C3, and every second column (from C) data compared to a different criteria C2. This works but it's...

I created a super-simplified pic of my Q below, but TLDR: I often want dozens of formula columns to calculate ONLY if a certain (sometimes-complex) criteria is met, so I use a standard =IF(criteria , if_true , if_false) syntax. Now because that criteria can often be complex, in order to keep my...

Hi there, I have long list of Dates as shown in column A below. In column B I want to return the Financial Period to which the date relates. The Financial Period is April to March each year, therefore, I have manually input the correct results in cells B2 & B3. Can a formula be written to...

I need some tips on how to improve the user form speed besides application.screenupdating, .enableevent, and .calculationmanual