Good morning everyone,
I have an issue i cannot solve for my excel file.. i explain
I received a file from a company where there is a pivot table with a filter (anyway this is what i think)...
I would like, based on the value choosen with the filter, to show only the correspondant product linked to this number.. I have insterted a screenshot explaning what i need
Excel issue.png
Would you have a solution for me ? (VBA or something else)
Thanks for your support
Guismo30
Can you provide a sample file, with dummy data, refer to the yellow banner above. VBA can be manipulated to hide rows that don't match the filter.
Hi
thanks for your answer, please find attached the file
Pierre
after working on this for a bit,I realized that you essentially want to data filter for a single value below row 9 inclusive, like in the diagram below.
fltr.png
One method I was considering to code the solution as to implement this filter in VBA. Do you still need a coded solution if you could filter like in the diagram?
Last edited by maniacb; 07-09-2020 at 10:36 AM. Reason: Corrections to response
In this version I have added two simple buttons, one to turn ON the filter and another to turn OFF the filter. You would need to select either button after selecting the part. Let me know your thoughts.
fltr1.png
Last edited by maniacb; 07-09-2020 at 06:07 PM. Reason: Update Picture
In this iteration i tied updating c4 with a worksheet_change event so that you don't have to select the turn on button . You'll still need to use the filter off to clear the autofilter. Here is the worksheet change code :
Here is the filter on and off code:
Please Login or Register to view this content.
Please Login or Register to view this content.
I hope this is the final iteration. a change event on C4 now hides all other columns. A button exist to reverse the hiding of rows. Maybe this is what you envisioned in the first place. Here is the code and the working file is attached.
Please Login or Register to view this content.
If the intention is to show only the Brick numbers that correspond to the value under Filter, then it's better to create a duplicate Brick column in the database and name the column header, say Brick2. Bring Brick2 to the Filters section with Brick remaining in the Rows section of the PivotTable.
Hello Maniacb
This is what i needthanks a lot for your support !!!
I however still need additional help from you if you do not mind...
As you could see, i have one sheet with attributes per brick (for ex brick 10000443 will have the 4.367, 4.391, 4.700 etc...) but for all the bricks there are fixed attributes that will have to be showing each time we filter the "brick" (like description, dimensions, weight, etc...) .. There are 192 attributes that need to show each time we filter the brick then followed by the "attributes per brick"... ==> as the 192 attributes have no "brick number" i do not know how to add them in the filtering
Do you understand what i mean ? I have added the 192 in the attached list, would you mind letting me know whether this is something possible?
Thanks again and regards!
Pierre
Last edited by guismo30; 07-13-2020 at 03:04 AM.
Hi Josephteh
not exactly what i wanted but thanks a lot
Pierre
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks