Hi,
need help on excel data.
Hi,
need help on excel data.
Hi,
i have data in sheet Raw Data. i have created pivot in "Validation data" for category and sub category. in the sheet "Yrl-Cat" i have used sumifs formula based on category and sub category. i want to filter a data such a way that when i select category in A5 cell of "Yrl-Cat" in the table sub category should get filter and shows only those sub category that belongs to the category selected in cell A5.
to understand the requirement i have created one example file which is attached here with.
can someone help me to fulfill my requirements.
Regards,
Amit Desai.
Hello amitad7,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks