fast

Hi Some help Is that any other way to filter fast 60,000 rows by a column like wise i have 3 columns with 60,000 rows it taking too many time to calculate & process. Very slow to do the work

Here is my whole code. A lot of it is very similar, just using different variables, but I kept it in for context. It's dealing with around 210,000 rows, and 11 columns, 7 of which are in-macro formulas (see bottom of code) which are copied then pasted as values. Basically, it was fairly fast...

Hello world. I'd appreciate some help as I'm really not sure how to solve this complex problem in an efficient manner. I need to find a fast way to price potentially hundreds of items. I know that loops will be the slowest thing in the world because of the sheer number of things that EACH ITEM...

<tbody> date email jan feb mar may jun jul aug sep oct nov dec 1/1 bob@gmail bob@gamail 2/2 eric@gmail eric@gmil 5/5/2014 helpme@excel.com helpme@excel.com </tbody> so what I'm working on is a sheet some what looks like this and Im...

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 been using this great website for a while, but I finally came across something that has stumped me, and I haven't seen in other posts. So here is my first post. So I have code that 'works', but I feel like it could be better. (And to be usable, it has to be) My problem involves a large...

Hello, I have a file 1 column and 100.000 rows filled with hexadecimal values that I want to convert to decimal. I have to use VBA and I need to find something really fast to convert this data. One idea is to copy the range in an array and access each element with a loop applying hex()...

I have a Sony Vaio laptop provided by work, which is faster than my old HP, bu it still takes ages to process spreadsheets (I use a lot of files in 5M plus but with lots of vlookups / sumifs) Is a MAC going to be faster?? I am already turning off auto calculate and reducing the autosave...

Hi, I have a big spreadsheet in Excel 2007 that contains 60,000 lines. I have named my range as "database". In another spreadsheet, I would like to build a macro that will import the range "database". Does anyone know what is the faster way to process? The current VBA procedure that I have...

Sub UpdatePurchase() Sheets("Main").Select Range("I4:I4203").Formula = "=SUMIFS(Entry!$I$4:$I$65557,Entry!$F$4:$F$65557,Main!E4,Entry!$H$4:$H$65557,Heads!$B$4)" Range("J4:J4203").Formula = "=SUMIFS(Entry!$J$4:$J$65557,Entry!$F$4:$F$65557,Main!E4,Entry!$H$4:$H$65557,Heads!$B$4)"...