dear experts,
Need help to build a macro which will find and filter data based on cell values and then copy filtered data and paste it in different sheet with some calculations.
Filters: selection by filtering with modalities: Country & Site.
1- Country: set all countries with a tick box for selection so there will be an option to select multiple countries at the same time or even ALL countries (please see excel file attached).
Ticking the boxes will trigger a “find and filter” function at all tabs level. The filter is applied at the specified column A in sheet IVRS
2- Site: free manual entry- “Find and filter” function with the site number (CRTN) at all tabs level.The filter is applied at the specified column B in sheet IVRS.
The information count from the corresponding individual tabs according to the filter applied- (country level, will only display country level count if no site is specified).
a- If the filter is applied at country level only.
HTML Code:
b- If the filter is applied at site : information displayed is the same as above but only for that site
Once the data is copy/pasted, cells must be formatted with borders and center alignment with font as 11 Arial. Also the previous filter data should be cleared prior to copy/paste of new filter data.HTML Code:
Could it be possible to copy data till last row in sheet IVRS based on column names in sheet dashboard row 12.
Regards,
Ketan
Bookmarks