Search results for query: *

I am having trouble writing code to use solver to get the correct asset allocation percentages. The problem I am having occurs when I enter my constraints. It seems that excel is only picking up 2 of my three constraints. Specifically, it is not picking up my constraint that says that the total...

I am having trouble writing code to use solver to get the correct asset allocation percentages. The problem I am having occurs when I enter my constraints. It seems that excel is only picking up 2 of my three constraints. Specifically, it is not picking up my constraint that says that the total...

I have a spreadsheet where I can click on any cell and the entire row will get highlighted in the color of my choice. For example, if I click on G10, all of row 10 will highlight in a light blue color. Now I want to be able to click anywhere in row 10 again and have the row go back to the...

I have a spreadsheet where I can click on any cell and the entire row will get highlighted in the color of my choice. For example, if I click on G10, all of row 10 will highlight in a light blue color. Now I want to be able to click anywhere in row 10 again and have the row go back to the...

I am trying to create a dynamic named range (actually a series of them) and have a summary table above them for easy viewing. For example my data starts in row 13 and my summary table goes from rows 4:10. My data goes from O13:O35 and is named "Variable1" my named range is defined as...

I am trying to take write VB code to help me facilitate a copy and paste. I want to copy information from EITHER Sheet 1: Column G or Column H to Sheet 2: Column B. I can copy it based on a double-click fine, but I want Sheet 2: Column B to know (when it gets copied) where it came from - either...