I can't seem to find in any posts I have searched how to build syntax to reference a dynamic start date (example: NOW -10). I can see how to incorporate the end date using NOW. My file has column A1 with dates starting with 1/1/2019 and goes to A365 with 12/31/2019. I want to "see" rows corresponding to the last 10 days (dynamic). My file is also attached. Thanks for your help!
Please Login or Register to view this content.
You can do that pretty easy with a filter. The code below uses the Worksheet_Activate event to trigger the macro.
copy the code to the worksheet code module. When the sheet is activated, it will filter the last ten days .Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks