performance issue

I think this is a common(ish) problem. I'm running an AHK macro that copies a series of contiguous and non contiguous cells. The data copied gets loaded into some variables and later pasted into a webform. This works fine - once. I can copy and paste all of my data in one go successfully once...

I have written a basic vba code to select bunch of rows from one sheet based on data paste it in another sheet where i perform duplicate removal and then I cut it and paste it in another sheet to get duplicate removed output, how to improve my code as the copy and pasting operations takes soo...

hello, I have loaded and converted over 300 text files in power query Excel 2016. Now I have about 1M lines that I am trying to do an aggregation on sum and count based on 2 criterias. I am running into some performance issues, it shows that my file is loading data for the last half hour but...

Hi all, I'm hoping someone has come across this and has a fix for me :) I'm extracting data from several files, each file has the same structure and I'm pulling multiple tables (but not stored as tables) from 20+ sheets in each. While all source files are closed the execution takes roughly...

I have three sheets ( 1.GCBC 2.RHPOOLLVL 3.Comparison Summary) inside my excel file. My goal is to fill the sheet 3 ('comparison summary') from the values of sheets 1 & 2. following is the code i have written to achieve the results, this is working fine but taking hell lot of time to complete...

Hi Everyone. I'm struggling with a functionality in excel / VBA. I have a list (one column) with 300.000+ entries. The length of each cell varies. For each cell over 35 chars, I need to perform substitutions in order to make it short. For that purpose, I have a range "from" --> "to", so at each...

Firstly I want to thank everyone who uses this site, it has helped me get where I am today, this is the first time I have come across a problem I haven't been able to find a solution for. I have written a macro that is essentially solving for the intersection between a line and a high order...

My company just "upgraded" to office 2013 and now one of my macros that ran perfectly in 2010 now seems to have a handful of issues. 1.It runs at a fraction of the speed ,2010- ~15 seconds per account vs 2013 ~ 1 minute per account.I have already tried disabling Animate controls and elements...

Hi, My company has recently upgraded from excel 2007 to 2013. We are using named ranges in order to store values in a database. One of our pricing tools have alot of named ranges, approx 75000. When running this tool in excel 2007, it works without any problems at all. When i run it on excel...

Hi all, I have a bit of an issue and thought this might be a good place to get some ideas. I have a set of data with client ID going vertically down and then horizontally I have the date the client moved to a certain status. I want to know at any given time how many clients are in each...

I have a table with values from A2:Y65000 and the Z2:AG6500 (formulas). I need this information in a pivot tables. I've listed each of the formulas below. I need some advice of what I can do to process this information quickly. Each time I add data or refresh it takes 5 min to calculate. Is it...

I'm fairly new to VBA in excel and have been going through several beginning books to try and accomplish getting values from closed workbooks on a network drive and populating them into my main Dashboard workbook. The only problem is they are for a running 13 months, so the files will change...

Hi, I´m trying to filter out unique names based on chosen year and organizational unit from a list that contains approx 20000 rows. Use code below, which is executed with a control button. I experience performance issues, the macro takes 5-10 sec to run. Is there any better way to do it? Sub...

Hi, I have pivot table and have to show the data from into another sheet as Report format. Format should not change.We are having only 4 categories.We have to show the catergory values as Header in Report (as shown below) By using Excel macros once the pivot table get refresh I am bringing...