Search results for query: *

I would like to know if there is a way to have Excel automatically group rows based on a Level Number. For instance, in the example below Excel would group everything from Rows 2-7 under Row 1, Rows 5-6 would be grouped under Row 4. You can manually do this using: Data -> Group and Outline ->...

I have a resource table that is broken down by month and by project, but some of the projects are grouped together later for reporting purposes. I want a formula that will check 2 condition columns, and then sum the corresponding data from a third column. In this example, Projects A and C are...

Cell "E12" is populated by validation. All other validated cells look to "E12" for information. If the value in cell "E12" is changed, all other cells should have any value in them cleared and be ready for a new value to be selected. The code I tried to use does not work... Private Sub...

The spreadsheet function is to "build" a motor with different options available to the user. The first pulldown combo box has a list of series (1series, 2series, 3series, etc.). The user has the option to select a desired series, and the next pulldown box should have options available...

I have a combo box where I can type in a part number. After typing in the number, I click on the pull down bar to view various information relating to the part number. I would like to be able to type in the number and hit 'Enter' and have the drop down appear with the information. I think I...

I have three different fields; series, identifier, and partcode (ex. sss-iippp). I want to type in the series and identifier into combo boxes and then click a button that will search the series and identifier fields for all partcodes associated with the inputed data. Then it should find the...