Trouble with Advanced Filter
G'day there Roger,
Sorry, the amended formula should, of course, be
=OFFSET(Data!$A$9,0,0,COUNTA(Data!$A$9:$A$65536),2 2)
Thanks muchly for that Roger, it works like a charm now. Or at least,
just like an XL spreadsheet :)
I've also followed your advice about shrinking the file. Oddly enough,
the filter still didn't work properly until after I did the shrinky bit.
However it's fine now.
Thanks very much for all the help I received. It's much appreciated.
Now all I have to do is build the rest of the application :D
Thanks again,
See ya
Ken
|