Filter Records

[stevekirk]

hi,

i have a qty field that i need to filter on, in the qty column there is an "x" as well as the quanties i need to filter on

i need to be able to filter on greater than 0 and aslo show the rows with x in

i need this in a macro

thanks
steve

[Bryan Hessey]

hi,

i have a qty field that i need to filter on, in the qty column there is an "x" as well as the quanties i need to filter on

i need to be able to filter on greater than 0 and aslo show the rows with x in

i need this in a macro

thanks
steve

If this is the 'x' in column C, D, G or X of Sheet1, would you not simply filter non-blanks on column I or J ?


If it is column A of sheet 2 you will need to duplicate column I of sheet 1 into a column on Sheet 2 for the filter.

---