Hello,
I am very new to VBA. I am building a sheet to display deadlines (rows) by project (columns). I would like to have it automatically hide the rows and columns based on the date of the deadline. If the deadline is today or 1 week from today the associated rows and columns should be visible, otherwise, I would like to hide them.
My table is A1:N9, with A1 being a blank, row names A2:A9, and column names B1:N1.
Any help would be greatly appreciated.
Thank you!
it would help us a lot if you could attach a workbook with your actual layout. Put some non-sensitive data in it to show us what it looks like. It is not clear to me right now as how you data are arranged, although I can imagine. But who would loose its time to work on an assumption. Right?
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
sample.xlsx
Sure - thanks for the reply!
Look at the attached workbook for 2 macros. One will hide or show columns and rows based on today's date. The other one will unhide all columns and rows so you can work on your table.
Here is the code:
Please Login or Register to view this content.
Thank you so much - that was very helpful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks