Code Simplification

Hello experts and users,

I wrote a code which was working fine but as the data changed, the procedure became rather cumbersome and I realised that it's not the most efficient way of writing it and I could easily have loads of mistakes in the process. So, I'm begging for your kindness and expertise to direct me to a way I could rewrite the following code in a more efficient and simplified way.

This is a dependent drop down list based on the selection made within the first field (ComboBox1) in this case.

I was thinking for probably creating a column for each case but unsure where to go from there.

Your help is much appreciated.

Best wishes,

Please Login or Register  to view this content.

Please see the yellow banner at the top of the page.

This is a little bit shorter but using the same structure:

Please Login or Register  to view this content.

The only other way I can think of is to have a table on a "Control" sheet somewhere that has a matrix of Service Type and Suppliers. Depending on the index for ComboBox1, you could loop through the suppliers for the service type.

You have the Lists available in Components Sheet so why not just give each list the correct Header referencing the Combobox drop down...
This will allow for a more simplistic approach...
This will give you an idea...i changed your sheets for testing...

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Alternative using proper tables - no need for separate component list - first combobox is populated from the table headers.