How to write VBA code to filter a field when opening a workbook?

[checkup2012]

Hi,

I want to write VBA code to filter a field (within a sheet) when opening a workbook.

For example, I have a workbook [alldata.xlsx]. Within this workbook, there is a sheet "Template" with the following fields:
ID ~~~~ Name ~~~~ Year ~~~~ Quarter ~~~~ Sales
.....................................
.....................................
.....................................

When I open the workbook [alldata.xlsx], the table in the sheet "Template" would filter the field ID with a criterion excluding blank values.

How to write the VBA code?


Thank you in advance

[p24leclerc]

supposing you have nothing else on this tab "DATA" you can use this macro:

Please Login or Register  to view this content.

[checkup2012]

Thank you Pierre.