Dear XL gurus
I face few problems in sample excel Attached
[INDENT]1.the Filter works only if all the B1, B2, B3 are fully entered
2.How to make even a blank Cell in B1, B2, B3 HAS To MEAN ALL possiblity
3.Number (B2) starts in '0' gives error. how to declare it as text?
4.Even If the B2 Cell contains part of the "Number" needs to be displayed (eg: 154 may result in 01540, 23154, 15456)
5.Why the dynamic Range doesn’t cover Whole Database?
6.A report of the result not copied in full to Report Page[/INDENT]