Filter a sheet and copy results to another sheet

[dixiV]

Hi
I was wondering if someone could help me.
I need to add two more criteria (from date and to date) filter
the code: http://www.vbaexpress.com/kb/getarticle.php?kb_id=786

Thanks very much in advance

[rounakbhasin]

Do you want all the filter criterion to be taken as an input via an input box or they are going to be value in some cell?

[dixiV]

...via an input box.

[rounakbhasin]

try this in the user form now insert 3 textfields instead of one

Please Login or Register  to view this content.

CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

[dixiV]

thank you very much
but, It's possible that....

Textbox1 = text (abc) = Column A
TextBox2 = date from (1.10.12) = Column B
Textbox3 = date to (4.10.12) = Column B
result:
textBox1 and (TextBox2 (up) to textbox3) => Sheet 2

Thanks very much

[rounakbhasin]

Pl. use this code

Please Login or Register  to view this content.

CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

[dixiV]

thank you very much