Hi,
I have a database where visible data total (filtered) is highlighted using SUBTOTAL(). Now I want the text which is appropriate and changes according to the filter. E.g,
when I select "UK" as the country and "Solar" as the fuel type in the autofilters, the text beside the SUBTOTAL value should be "UK Solar Capacity".
Hope there is a way and I get introduced to it in this forum. Thanks.
Vinay
Hi and welcome to the forum
Cant you just look at the top if the list where the filters are and see which 1's have the funnel - indicating that column is filtered?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I believe you should go for VBA code to do this job
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
for better result advice u to attached sample data sheet!
Hi,
You can also get help from internet.
grays solar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks