How to hide/show cells by a drop down button on parent cell ?

[avnthk]

Hello !

I want an option, if click on drop down button on parent cell than few a cells will come out in which I have mentioned details of the parent cell.

By pressing the same button again those cells will be hidden or covered under parent cell. ​

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[azumi]

Not sure without seeing your file and your expected results, try to upload your sample file/workbook, click "Go Advanced" button and find Paperclip Button to attach your file

Regards

[avnthk]

@azumi
Find attachedsample.xlsx

[avnthk]

@azumi
Find attachedAttachment 337259

I want to put a button on cell where "A" written to hide/ show "a-d" series below.

[:) Sixthsense :)]

Not sure where you have the drop down and the concerned data and all

[avnthk]

What need is :

A drop down button in A1 cell, by use of which I can hide/show cell no A2-A5

[:) Sixthsense :)]

Please confirm why A1 consist the text "A"?

What will be the drop down textS of cell A1?

[avnthk]

"A" is just to fill the cell.

Cell matter/text could be anything I just want something in the A1 cell cell so that I can hide/show A2-A5 cells.

[:) Sixthsense :)]

Check the attached file and confirm

[azumi]

Maybe something like this? Using array formula and helper column

[:) Sixthsense :)]

Hi azumi,

I think you can avoid array in this way...

In A3 cell of your file

=IFERROR(INDEX($D$3:$G$6,ROWS($1:1),MATCH($A$2,$D$2:$G$2,0)),"")

Dragged down...

[azumi]

@Sixthsense
Yes sure, sometimes I cant' thing a simple way.. lol

[avnthk]

Validation With SheetChange Event Code.xlsm

@Sixth Sense: I have attached excel sheet.

I have explained my requirements inside the sheet. Please help. Once done teach me how did you do that.

[avnthk]

Plz help with the xcel sheet