Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding rows based on a date function
I have a spread sheet which can vary from 8k to 12k lines long.
Row 1 contains header information. Column Y can contain either blank cells, or cells with dates. Excel 2003. I need to run through all the rows, look at the value in column Y, and determine if it is more than 100 days from todays date. "today" meaning whatever the date is when the macro is run. If the date in Y is more than 100 days from todays date, I need to hide the entire row. Can anybody provide help with this? Many thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows based value of cell within row | Excel Discussion (Misc queries) | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding rows based on a value | Excel Discussion (Misc queries) | |||
Hiding Rows Based on Percentile | Excel Discussion (Misc queries) | |||
Hiding rows based on date | Excel Worksheet Functions |