Hi ... Wondering if someone can help me with the following:

Below are the requirements for the Macro following the instructions one after the other:
1. Filter by [column P] ------- > “Ireland”, “Great Britain”

2. Filter by [column Q] ------- > “UK - MANAGED SERVICES” , “IRE - IT Solutions & Services”

3. Split into different worksheets (4 worksheets each named after filter criteria)
i. Filter and Split by [column HH] --------- > a) “ON HOLD” , b) “Live” , c) “Request Approval”
ii. Filter and Split by [column BV] ---------- > “Suman Ray”

4. Delete all Empty Columns on the new worksheets which only has a header

Would appreciate if someone can help me out on this.

Many thanks