Hi,
I need help, Once i click the check boxes in "EMEA_in_depth-21Sep Till Date" sheet then data will show in below format and once i unchecked the boxes then data will remove form the below. Data will fetch from "Raw Data - Reports" sheet. Every week i will add more data in "Raw Data - Reports" sheet. Can it possible by VBA code? please help
Last edited by Sanjibghosh; 11-02-2016 at 08:47 AM.
Hello
Maybe you could adapt this Advanced filter macro. In the attached file I've applied code to each check box, which places the Check Box caption into the criteria range in P9:P12. The macro is run from the filter command button. The filter code uses the Current Region, so if new lines are added to the Raw Data then these will be included, this feature relies on a empty column and row to the right and below the current data.
Hope this helps.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks