Good Afternoon,
I have a table of call tariffs and prices etc...
Now certain parts of the business only have authority the sell certain tariffs.
I am trying to create an auto filter based on the selection from a validation box. This will then be used on a user form in VBA.
<colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
As you can see the filter will be based on "1" & "0"
Any Advise will be greatly appreciated.
Thanks
Peter
I have a table of call tariffs and prices etc...
Now certain parts of the business only have authority the sell certain tariffs.
I am trying to create an auto filter based on the selection from a validation box. This will then be used on a user form in VBA.
| Tariff List | SME100 | Enterprise | Customer Loyalty | Account Management | Standard Dealer 40% | Standard Dealer 10% | Introcucer | Introcucer F&F | Base Buster |
| None | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 3G Mobile Broadband 1GB Migration | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 3G Mobile Broadband 1GB New/Port | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 3G Mobile Broadband 1GB Resign | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 4G Mobile Broadband 1GB Migration | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 4G Mobile Broadband 1GB New/Port | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 4G Mobile Broadband 1GB Resign | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 4G Mobile Broadband 3GB Migration | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| 4G Mobile Broadband 3GB New/Port | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
<colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
As you can see the filter will be based on "1" & "0"
Any Advise will be greatly appreciated.
Thanks
Peter
Last edited:
