PDA

View Full Version : Help with macro for filter



Roman76
02-18-2016, 01:50 AM
Hi,
this is my first post. I hope you can help me. I have a macro that filters data after searching. It works great but there are 2 problems:
1. After typing for the search the macro shows a message box with following text :"Soll nach einem Datum gesucht werden?". This is not want I want. I tried to delete some lines from the code but no chance to get it work. I always got an error message. How can I delete it?
2. The macro always opens a new sheet. I want to have the results on sheet "Filter" starting on A2

Can you help me?
Thanks a lot!!

Kind Regards

P.S. Sorry for my english..... :)

Bob Phillips
02-18-2016, 03:37 AM
This is all very confusing. That message is about dates, there are no dates in the data, and when I put in a search term, it fails because it is trying to get a date value where there is no date.

What are you trying to do here?

Roman76
02-18-2016, 04:12 AM
Hi xld,
I don't need to search for a date. So i want to delete this from the code.
I just want to search for some dara and get the results.
I found this macro and the search function was already in the code.
Kind Regards