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

[checkup2012a]

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

 

[PHV]

Thz macro recorder is your friend.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[UnsolvedCoding]

I agree with PHV. As an added thought, when recording, sort so that blanks are on the bottom.