processing time

Hello, I am looking for a way to improve the calculation speed in my workbook. Currently I have six macro buttons doing the same for all six departments (here D2S). Sub D2S_Button() 'Description: This macro will loop through a row and 'hide the column if the cell in row 1 of the column 'has...

My code works and executes exactly what I need it to do, but I would like to improve it's processing time as updating each individual cell is significantly slowing down my macro. Currently, I am using VBA to do an Index & Match formula with another workbook where it retrieves information...

Hello- I have an individual patient simulation model that I have built in excel. In order to improve the processing speed I have been told that there is a way to have all of the simulations run in VBA and not documented line by line in excel. I was told that there is also a way to print a report...

I have a large table of data that spans 24 columns and 18K of rows. I want to have an output that scans the mass data and returns 24 columns of only 365 rows (1 year or maybe 2). That will further be processed into a few rows calculating Std Dev, Median, Mean, Percentile, etc. In terms of...

Hi guys, Excel 2010 on Win 7 64bit Below is my code to date that in short outlines the behaviours of my reporting function. This code is run from a master workbook that references tables of data contained within several other open workbooks that are hidden in the background. Workbooks...

Hello, I am trying to find the right formula to use in my spreadsheet for work to calculate my specialists processing and average time. I have several columns with large data but every month I need to know the average processing time by for each specialists. I am sure this question has been...