Apply Auto Filter Based on Date Input by User

[ELDAN]

I've written a macro (Live recorded) that cuts a date from one cell and pastes that date into the macro. My intent was to have someone (that knows nothing about macros) be able to put a date into that cell and click on the macro button and auto filter would give them all the information for that date (& do several other things also). The macro works the 1st time and then that date stays in the macro no matter what you put subsequently in the cell..How do I get the macro to copy and past the new information put into that cell into the macro each time automatically?

[Palmetto]

ELDAN,

Welcome to the Forum. However, please take few moment to read the Forum Rules regarding thread titles. Your thread title should be "search friendly" - meaning it would return relevant results if someone used your title as search terms.

Rule #1

Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

Suggested title: Apply Auto Filter Based on Date Input by User