optimisation

Dear friends, I have the following issue with a macro that collates near 600 tables (5x13) and paste them in different sheets in order. In other words, the macro builds a DB with hundreds of tables distributed in several sheets. Because it needs to copy and paste so many cells the macro became...

Dear all I'm currently working in a giant budget spreadsheet with lots of data. I have a macro that i need to run to update my numbers. My issue is that it takes 8 min for it to finish which is quite frustrating. Does any of you have the skills and will to see my macro through and see if...

Hello all, I have a set of values which depict the length of steel rods. But manufacturer has default values of 40feet, 50feet and 60feet. I need to find how many 40', 50', 60' units shall come. The wastage should be minimum. I have done it manually, but have lot of data. wastage is about 6.9...

Hi, I am totally new to VBA and have been working on portfolio optimisation with mean-variance framework using solver with rolling window. I have managed to set up a simple linked model and excel and have been using Solver manually to compute the weights (minimising the variance as well as...

Hello everyone, i would like your opinion on the following: I need to extract data from several word documents (about 80 pages each). These documents have somewhat of a standard formatting that enables the structured extraction. Example: word in upper case in document will go to column B...

Hi there, I've got two columns B & C. A B C D 140% 140% 78% 78% B corresponds to A and C corresponds to D. At the end of the day I want to have both B & C to...

Hello I'm once again troubling this forum's community with a puzzle that has been driving me crazy for the past 2 days. I wrote a code that has to insert rows when certain conditions are met. The code finds the conditions, reads a number (X) in a row that meets those conditions and inserts X...

I have a macro that distributes my 10 meg master file into a file per customer. I am trying to reduce the size of the final output and wish to copy the charts on each tab and paste them as pictures in the customer's own output file. can anybody assist please? Sub CUSTOMDIFOT() '/// this macro...

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I came up with this one off the cuff and wondered if there was a different way. Here are the pertinent details. <o:p></o:p> I have unsorted data. Column E-I are performing the same lookup using a...

I have worked with some high end optimisation tools that allowed me to build some very complex models that were solved to optimise the business processes of my clients. These tools were very powerful but they were also very expensive. The models I built were large scale Mixed Integer LPs. I am...