[VBA] Hiding columns when a certain Value is displayed.

[Palmajr]

I have a problem, and I have absolutely no idea how to fix it.

Let's say, we have a full column with dropdowns. In each dropdown, there's a certain type of data, I'm going to use cars for an example.
We also have a full line with specifications.

Now, imagine we go to A1, which is the dropdown column, and we pick Ford (car brand). When I pick Ford, I want excel to hide all the columns EXCEPT the columns with the specification data about Ford.
Let's say Ford is associated with lines such as Engine, Consumption and Torque, but there's lots and lots of other lines like, Electrical Consumption etc.
When I pick Ford in the Dropdown, I want excel to hide everything and only display the columns that say "Engine, Consumption and Torque" in a way I can fill them up.
Now, let's imagine that in the dropdown below, I pick Electric Car Brand. I want Excel to hide all the other columns, and display "Electrical Consumption, *Specification 1* and *Specification 2*

How am I able to achieve this? The closest thing I've saw are macros, but my level of knowledge on excel is still quite low and I'm not understanding how to get them working. I would love if someone could help me out with this.

[AliGW]

Please explain how this request differs from the one I answered previously with this solution:

Excel 2016 (Windows) 32 bit

	B	C	D	E	F	G	H	I
19	Tool Name	Brand	Product Type	Power	Electrical Consumption	Cutting Depth
20	Electrical Saw ES433	AEG	Electrical Saw

Sheet: Folha1

Excel 2016 (Windows) 32 bit

	E
19	=IFERROR(HLOOKUP($D$20,Specifications!$B$2:$D$5,COLUMNS($D$19:E19),0),"")

Sheet: Folha1

[Palmajr]

Okay, basically I need to have everything on the same excel page. On the one we discussed, the other data was on another page, and also, when I typed the "Product type" the fields automatically changed, that is correct and so far so good.
Now, what I need to get done is to have static fields (Doesn't matter how many, can be hundreds) and I need those fields to be shown whenever I change the "Product type".

I am sorry if it sounds of similar nature, but the problem is completely different

[AliGW]

Well, could you please provide another workbook, then? You need to mock up what you want to achieve with some examples of expected outcomes. I suspect that the solution will not in fact be a million miles away from what you have already, but we'll see. Attach the new workbook here.

[Palmajr]

I'll try to.

[AliGW]

Thank you - it will help. Just to clarify: will the objective be to filter and display data that already exists OR to enter new data?

[Palmajr]

Here it is. I've explained how I want it to work in the file itself.

[AliGW]

I cannot see how this differs from what you asked for before, so answer the following, please: what is the purpose of this? Are you wanting to view data that exists or to add data?

[Palmajr]

Add data. Let me insert an Excel file with something that's already "manually filled" but not fully functional.
I think you'll understand better that way.
Basically, in this file, you can see each type of tool and only the fields that correspond to it are filled. I want a simple way to see the fields for that type of tool without having to see the others.

[AliGW]

Thanks - yes, it is much clearer now. You are going to need a VBA solution, and I am afraid I am not able to help with this. I would recommend that you go back to your opening post and edit the thread title so that VBA is visible as part of it - this will signal to those who can help that you need VBA.

[Palmajr]

I am so thankful for this, AliGW. I will do this.

[AliGW]

You're welcome - I hope you get some help soon!

[davesexcel]

Do you want to select something from the dropdown in A1, once selected, it will filter a specific column for that item?
There is a sample here to AutoFilter as you type
http://www.excelforum.com/excel-gene...-you-type.html
I also have an old YouTube example
https://www.youtube.com/watch?v=E6Nj2vIvlpI

[FlameRetired]

This is another approach.

I assume you know how to build a drop down in D6.

That done try array entering this in E15 and filling across. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

[FlameRetired]

Instead of my previous this one is simpler and does not have to be array entered. Enter in D15 and fill across this time.

Please Login or Register  to view this content.

[Palmajr]

I was looking for something like this. Wondering if it's possible for multiple columns.
https://www.youtube.com/watch?v=Rv-cp0bPGx4