Need macro to copy a date from a cell and paste into drop down column filter

I'm trying to allow a user to enter a date into a cell and have a macro simply copy the date and paste into 'Date Filters' in the drop down filter at the top of a column. I've recorded the macro to do just that, but it seems to keep the original date I entered when recording the macro even after changing it in the cell and running again. Is this not achievable the way I have set it up? Many thanks..

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Try this. I would be happy to test it if you provide your file:

Please Login or Register  to view this content.

Ah, sorry about the rule. Now I know.. I just tested that and it is reading from cell A2 in the wrong sheet. I need it to read from "Enter_Date" sheet, and the filter is on "Enabled_Only"

For code like this it is important to mention what module it is in, and what sheets you are working with. I am guessing a generic module like Module1. In that case it is better to explicitly identify sheets, rather than use defaults or ActiveSheet.

Please Login or Register  to view this content.

That worked, thanks!

You're welcome!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationicon.jpg below their name.