optimize

So I have created this MACRO for work, to ensure everything is getting charged right. Well I would like it to run through pretty much the entire database data for 2 years, I can not get it to last that long. I can copy the data to a separate spreadsheet and run the macro in chunks, but I would...

(Spoiler, long post) Hello all, I am relatively uneducated when it comes to VBA, but I have muddled my way into a semi-functioning project that until recently worked fine. Let me begin with a little background. I work in Security and we moved to a different Asset Tracking system a little bit...

Hi, not sure how to best use excel to solve the following.... <tbody> Gender Material Qty </tbody> I have the following information. I need to group the Materials by gender with a max of 5000 qty per group without partially splitting the materials into 2 separate groups. Any help or...

Hi. This question is purely for my own learning experience. I have the code below which works perfectly for what I want. I’m just interested in knowing if there’s a way to optimize the code even further and reduce the number of lines. The code checks which of the three checkboxes I have listed...

Hi, It's been some time since my last post on this board, but now I have new challenge. In short: Is there a way in Excel to calculate the optimal product mix, so that as many orders as possible are fulfilled and at the same time, as many picking orders as possible goes above a certain picking...

Hi VBA people, I know that many advanced VBA users advocate getting away from using selects. It seems there are many work arounds. However, I have a project where a .select might be best. I would like to get the user community's feedback on how optimize and improve this process: ' Copy the...

I've adjusted many settings in my workbook, but I can't remember exactly what I've changed. Is there any way to recover the workbook's default settings? My workbook has become more slow when I use it, but I can't see any big changes. Is it possible that some cells are 'in use' even though I...

Currently I do this: Code: For CurrentTableRow = WallTableBeginsRow To WallTableBeginsRow + NumberOfWalls If (Cells(CurrentTableRow, BwkBlkStudCol).Value = "Bwk") And (Cells(CurrentTableRow, FloorCol).Value = "GF") Then GFBWKArrayNumber = GFBWKArrayNumber + 1...

Hi all, I wrote a lengthy macro that copies a number of cells from one workbook to another and I reference the cells via the syntax below.... Since I'm constantly repeating the bold portion, I'm wondering if setting a variable = to the bold portion would speed things up...

I have a very large range of formulas that spans E6:YO6052. Each cell in the range performs a few simple calculations (some multiplication and addition). There are no dependents inside the range (i.e. all the formulas reference cells outside the range and these cells are not dependent on any...

I am working on the following problem and now realizing that my previous (ridiculously complex solution), is only a partial solution. I would appreciate any help! I have a matrix that can expand in either direction (limited to 220 rows and roughly 90 columns). I am indicating the...

I have an in-house list for tracking samples through a process. I get a vendor list that shows the status of those products in our store. I am looking to centralize the data into a single Spreadsheet so that all relevant information is readily available for reporting to the team. Here is my...

this is the...

Hi everyone, This is a bit related to my last post: http://www.mrexcel.com/forum/showthread.php?p=1991644 What I am trying to do is create a specific "optimizer" type macro for some data I will have. What I'm working with is a spreadsheet has the $ costs for different projects and an...

Solver and Drop down menus problems I'm trying to use Solver to Optimize a simulator I built in excel. The target cell is Market Share and the adjustable cells are drop down menu links. In other words, the drop down boxes change the price of a product and that affects the share. The issue I'm...