Macro to Auto hide certain rows in a calendar or Time Sheet.
Hi,
I am trying to create a Driver's Overtime Sheet. I want to select any month in cell C2 & the relevant dates are filled in the subsequent 31 rows. But the problem is that in case of February, April etc. (Months having <=30 days), some dates of the next month are displayed. I want a macro to automatically hide that/those rows when the month is changed in cell C2 (most probably with a worksheet change event).
Any help is highly appreciated.
Thanks in advance.
Last edited by excellon; 10-02-2019 at 02:07 PM.
Hello excellon and Welcome to Excel Forum.
The following won't hide a row, however it will suppress the display of days that are not in the current (as selected in cell C2) month.
Paste the following into cell A6 and copy down: =IF(MONTH(A5+1)=MONTH(C$2),A5+1,"")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc,
Thanks for your help.
As you said, your formula did not hide the next month rows but kept them blank though the last row showed error value as its predecessor had no month. so, I put an IFERROR function to the whole formula and now the next month rows are blank.
Now, I would like to hide those 1 or 2 blank rows upon the selection of the month in C2.
Can you please help further?
Thanks again.
Well, I found the code in the stackoverflow Forum.
I have triggered the code with Worksheet Change & it worked:
Thanks to excelforum.
Please Login or Register to view this content.
Last edited by Pepe Le Mokko; 10-05-2019 at 03:02 AM.
Glad that you found a solution. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks