Dear Excel Experts,
I hope I can find a solution here to my problem. It's rather simple, I would like to use a pre-filled dropdown or combobox to control/filter a pivot table. I tried to find a solution but couldn't find an answer. Please find attached a sample file.
For any help, I would be very grateful! Thanks!
i will suggest create template and use sumifs function
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks