Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows depending on the date
Hi all,
This should be easy: I need to write code which hides a specific set of rows if it happends to be past a certain date. It is for a group of four tabs which report sales in each of the four quarters and also inform the staff of where they should be to quarter based on the date (it's this latter info i want to hide when the quarter is over so that they can still review the sales, but not get distracted by the (now invalid) surplus data). Each tab contains a small list of dates which my target calculations are powered by and I would like to use these to power the above code if at all possible Thanks foir any help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows depending on the date
This may sound odd, but why don't you use a simple filter ?
Why the need to write code ? -- Regards; Mark Rosenkrantz -- Spreadsheet Solutions Uithoorn Netherlands -- E: W: www.spreadsheetsolutions.nl -- "teafan" wrote in message ... Hi all, This should be easy: I need to write code which hides a specific set of rows if it happends to be past a certain date. It is for a group of four tabs which report sales in each of the four quarters and also inform the staff of where they should be to quarter based on the date (it's this latter info i want to hide when the quarter is over so that they can still review the sales, but not get distracted by the (now invalid) surplus data). Each tab contains a small list of dates which my target calculations are powered by and I would like to use these to power the above code if at all possible Thanks foir any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto copy data rows between sheets depending on date entry | New Users to Excel | |||
Worksheet Change: Display/hide columns depending on date | Excel Programming | |||
hide button depending on date | Excel Worksheet Functions | |||
hiding rows depending on the date | Excel Discussion (Misc queries) | |||
hide/unhide rows depending on the top input value | Excel Programming |