Get instant live Excel expert help to learn how to find max and min in Excel?

Need help to transfer charts from Excel Template to PPT I will not take more than 20 min. I only have 2 questions - 1) i need to move to next active sheet in the workbook. 2) need to copy 20 slides from excel to ppt and ppt is restarting after a few. so need to know why.

I have a huge sheet that imports external data from a server, it has 10,000+ rows and I have added more than 100 columns of calculations. I am using Solver to get min value of LSE of a nonlinear equation vs. every row. I am not sure if it is beyond the VBA capability or not ? The run kills my machine, even with using the 4 processors of core i7. I tried to disable the following items for quicker run using two pieces of code before and after my main Solver code (attached below), but with no success: 1. Screen Updating 2. Displaying Page Breaks 3. Calculation Modes It still takes ages to just do tens of rows, and many times it exceeds the time limit. Any advice on that excercise? Thank you! ------------------------------------------- Public CalcState As Long Public EventState As Boolean Public PageBreakState As Boolean Sub OptimizeCode_Begin() Application.ScreenUpdating = False EventState = Application.EnableEvents Application.EnableEvents = False CalcState = Application.Calculation Application.Calculation = xlCalculationManual PageBreakState = ActiveSheet.DisplayPageBreaks ActiveSheet.DisplayPageBreaks = False End Sub -------------------------------------------------------------------------- Sub OptimizeCode_End() ActiveSheet.DisplayPageBreaks = PageBreakState Application.Calculation = CalcState Application.EnableEvents = EventState Application.ScreenUpdating = True End Sub --------------------------------------------------------------------------

I need to combine two Excel files having all of the tabs, macros, etc.. from the Small Business template, brought over to the Master TimeSheet Calculate following the Employee Information tab. I need them combined so I have one excel file that is not linked to any other file than itself. There are Macros involved. I am willing to go beyond the 20 min mark.

I want to create task management sheet. Please someone help me, I am trying this from 30 min.

Solve the following LP problem using the simplex method: min z = x 1 − 2 x 2 2 x 1 + 3 x 3 = 1 3 x 1 + 2 x 2 − x 3 = 5 x 1 , x 2 , x 3 ≥ 0 .

Solve the following LP problem using the dual simplex method. min 3x1 + 4x2 + 5x3 2x1 + 2x2 + x3 ≥ 6 x1 + 2x2 + 3x3 ≥ 5 x1, x2, x3 ≥ 0. What are the advantages with respect to the primal simplex method?

I have a MIN formula excel. If the range only contains N/A I want the MIN to populate N/A instead of 0.

The project is simple and consist in : (From an excel sheet) 1) automate login into website 2) copy and paste data from an excel file into the website 3) copy and paste data generated from the website on the excel sheet. This is done manually today and it takes 5 min for each line to copy and paste.

very simple work, just it will take 2 min.

I have 5 sheets in one workbook. Sheet 1 finds the MIN value in certain cells within the other 4 sheets. I need a formula in sheet 1 that does the following: If MIN value was found on sheet 3, cell A5, then I need to paste data from 2 other cells (not adjacent) on sheet 3 to sheet 1. If MIN value was found on sheet 4, then the data from 2 other cells on sheet 4 needs to go to 2 cells on sheet 1. So whatever sheet the MIN value is found on, it has 2 cells with corresponding data that need to be pulled to 2 cells on sheet one based on the result of the MIN formula. Thanks!