Forum Discussion
Macros for hiding rows based on date
NikolinoDE Thank you! That did not work for me but will keep working on it. The best way to describe it is in the 2nd worksheet, if Column A2 ( or all of Column A) row 2 (multiple rows) has a value in it (the name) and Column F2 (all of column F2) row 2 (multiple rows) has a date earlier than today (<date) then hide the row. Would also like to unhide if needed. Hope this makes sense.
Sry for the late answer, but the pastis in the bistro was very tasty, took a little longer :).
Here is a small suggestion for a solution. As far as tested on the quick, it works.
* I freed the file from useless entries, so it has become much smaller and more manageable.
Hope the proposed solution fits into your project.
File inserted.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
NikolinoDE Thank you for your work! It did not work - it takes away the last few rows and not any of the rows which "14 day return to work" column is before "todays" date.