Macro on attached file "hard wires" the autofilter for Col A of the table to show only any date(s) in May 18:
How can I set the "autofilter" to use whichever month the User selects from the DropList in G1, and have it still list ALL the date(s) for that month, and not just the specific date in G1?,
Please Login or Register to view this content.
All suggestions, pointers and solutions welcome as ever
Ochimus
here's one way
Please Login or Register to view this content.
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.
Hello Ochimus,
Here is another way...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks to both for solutions.
Fascinating that Excel seems always to offer multiple approaches to any need!
Ochimus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks