performance

I have about 10 cells in a row that contain strings. These strings can be null to paragraphs of text. I need to find out if a particular key word exists in any of the cells, for each row through hundreds of thousands of rows, then this gets nested in another loop - so I need this to be fast...

Hello, I recently changed from office 32bit to office 64bit as I had hoped that it would bring an increase in performance. I have one macro that I use regurlarly, it searches through lots of arrays generated from csv data imported to memory. This macro took two and a half minutes te execute on...

Greetings, I'm in a bit of a dilemma and hope that someone can help For reference, the module I am using can be found here: https://github.com/VBA-tools/VBA-Web I need to develop an excel add-in that plugs some data from a cell into a function, sends that data to the backend of a web...

Hi I am currenlty using the following formula in excel, but due to the repetition it is causing significant performance issues. I was hoping that if I could add this in as a macro instead, this would improve the performance of the sheet and make the excel doc a bit more stable. I have done some...

Dear developers, I have created a VBA application to process commissions and would like your feedback on how I can improve the performance on calculations on 20,000 rows of data. For instance, to calculate product margin I have used application.WorsheetFunction.SumIfs. Below is an image of my...

I have created a spreadsheet to compare the performance of last month's social media performance with this month's. For my data, I have used the IF function. Although this is working with symbols and text, I want it to change the colour of the cell based on the data from the cells that are...

Dear all, I am trying to compute carry or performance fee for a hypothetical fund. The performance fee or carry is 20% of total profit, provided 1) Hurdle rate or threshold is met 2) High water mark (HWM) clause, i.e. no performance fee is paid unless the net asset value (NAV) for this...

I'm assembling a list of amateur athlete performances from various competitions. Data for each competition is assembled in separate tables, which includes multiple fields for their performance. The athlete ID is two fields; 'First_Name' and 'Last_Name'. The performance data also has...

Hello Everyone, I recently opened up a retail store. Transactions are completed in a POS system that allows me to download reports. They are however not sufficient for me to do the analysis I need - hence I need excel help please! I am trying to create a dashboard to measure individual and...

Re: Excel Macros Dear Mr. Excel, Has anyone had experience working with macros in Excel? Recently, I was reading about their use within Windows Server; I wish I had something like this at work. Something to assist me with reports assemble charts, plots, summarize performance data. This...

Hi All I have a spreadsheet with 10,000s of Theatre Box Office records. Each record is a count of the number of tickets sold by Show, Date, and Ticket Type. For example some records may look like this: <tbody> Show Type Show Name Performance Date Day Ticket Type Tickets Sold Christmas Show...

Sumif from pivot table by criteria (Greater Than) 've tried all possible ways, sum if, sum product, index an match, etc. but whenever I go back and filter its also picking up the grand total number located in the pivot table. Therefore in lieu of the correct number (example $17,393) it...

Hi, I need to calculate YTD performance starting from Apr-17 to Mar-18 not from Jan. Can anyone help me out please

Hello I'm using this board quite a few times but I never posted a question. I'm working on a special project in my company and for this project we use excel and vba code. We got a strange behavior. With VBA we import data from other workbooks into the main workbook. This tooks about 30s for...

Hey guys, I'm new here and have a beginners questions. I have created a userform for data entry (code below). The form takes approximately 12 seconds to transfer the data to the spreadsheet. I have tried the recommendations in the following page...

Hello, Hoping someone will be able to help as I've hit a brick wall!! I have created bullet charts to show finance and performance all on one chart for all the organisations we work with. The performance side of things works well but the finance only works if the organisation has either spent...

Hello, I have the following code which is 99% working as intended Sub ThreeSheets() 'Turn off screen updating Application.ScreenUpdating = False 'Make the hidden worksheets unhidden so I can copy them Worksheets("April Performance").Visible = True Worksheets("May Performance").Visible = True...

Hi Everyone, I am looking for help with a formula to return multiple answers depending a cells input. For example: 6 = Good performance 5 = Satisfactory performance 4 = Acceptable performance 3 =Requires improvement* and so. and so on. I have a basic formula...

Hi, I am working on file to show the team performance and i need to add a slider that reflects the performance back to back in dashboard.. Eg: If He goes from 20 to 30 The machine should show the same range..

My file's not large in absolute terms (2MB), but has a dozen worksheets, several thousand formulas, a bunch of VBA macros I run, and on top of that is pulling in real-time tick-by-tick stock market data via DDE. This results in a lot of lag, and occasional crashes. (In the lower-right of the...