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.
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.
Last edited by avnthk; 08-05-2014 at 11:51 PM. Reason: language
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
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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
@azumi
Find attachedsample.xlsx
@azumi
Find attachedAttachment 337259
I want to put a button on cell where "A" written to hide/ show "a-d" series below.
Not sure where you have the drop down and the concerned data and all
What need is :
A drop down button in A1 cell, by use of which I can hide/show cell no A2-A5
Please confirm why A1 consist the text "A"?
What will be the drop down textS of cell A1?
"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.
Check the attached file and confirm
Maybe something like this? Using array formula and helper column
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...
@Sixthsense
Yes sure, sometimes I cant' thing a simple way.. lol
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.
Plz help with the xcel sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks