Filter with Code

  • Thread starter Thread starter John
  • Start date Start date
J

John

I'm a newbie to filters and can do one manually but I'm looking for code
that will do the following

I have a series of data in 7 columns, 3 of my columns are detailed below and
I wish to filter out only those within Salary type that equals "Mth" and
place them (with the exact same headings etc in a sheet titled "filtered"

StaffNo SalaryType PayRate
1 Week $8.90
2 Week $10.00
3 Mth $15.00
4 Week $7.50
 
Try recording a macro while you do this. If you need more help, post your
code for comments.
 
Back
Top