Search results for query: *

Autofilter does not accomplish what I'm looking for. In the example above if I ran an autofilter for level 2's this would be the output: Row Level 2 2 3 2 4 2 7 2 8 2 What I would like to have is a spreadsheet that allows me to explode and/or colapse a BOM based on the...

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 ->...

That worked great. Thank you! I agree, it's time for me to learn PivotTables.

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...

Thanks Robert, it worked perfectly! Thanks again to both of you, very helpful!

Thanks logius! This did do what I asked; however, after seeing how the spreadsheet now operates I have a different question. As mentioned before cell "E12" in populated via validation. Is it possible for the dependant cells to clear only if the value in "E12" changes, rather than just if...

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 part where the ListFillRange is populated from the offset command.

Skip, Since you use this approach often, is there anyway you could send a sample spreadsheet to demonstrate this? I have studied the OFFSET function, but it just isn't making sense to me.

Skip, Thanks for trying to help. I don't think we're quite on the same page though and I don't know how to explain it any differently. I tryed the match, countif, and offset functions, but they still don't populate a combobox. Thanks again.

Skip, OK. So I have one shaft list, one frame list, etc. How do I use the MATCH and COUNTIF functions to populate a combobox?

Skip, I am not sure what you mean by "discourage you from naming individual ranges of the same kind like 1Shaft, 2Shaft, 3Shaft,etc.; 1frame, 2frame, 3frame"? I have a worksheet with a list named Series populated as follows: Series1 Series2 Series3 Series4 etc... Depending on which series is...

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...

Thanks. The DMax worked great. No queries necessary, one line of code did it all. Thanks again.

The dmax function will work at the end to find the highest partcode and add 1, but how do I search the series and identifier fields and find only the highest value partcode associated with the inputed data?

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...