Auto filter

[jOE]

Hi,

Is there a way that specify autofilter criteria, eg I
have two columns:

Task Job
a1
b1
c1 d1


After either autofilter or other methods,the outputs will
show as follows

Task Job
a1 b1
c1 d1

many thanks.

regards,
Joe

 

[Frank Kabel]

Hi
not possible with Autofilter. You want to delete all empty cells?. Try
the following:
- select your entire data range
- hit F5 and click 'Special'
- choose 'Empty cells'
- now right click on one of the highlighted cells
- choose 'Delete cells'