| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding rows depending on the date
I have some hidden rows that I would like to become visible on january 1st.
I will not be available to manually unhide the data. Can I (you!) write a formula that will unhide my data on January 1st? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding rows depending on the date
I have a similar question. Is there a way to automatically hide rows based
on a comparison of the date in each row's first cell and the current date? I do not want to delete these rows (some users will want to access them occasionally), but since they are old I also do not want them to show anymore. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding rows depending on the date
Data Filter AutoFilter Custom AutoFilter Select date is less than
1/1/2007 OK "Jan Buckley" wrote: I have some hidden rows that I would like to become visible on january 1st. I will not be available to manually unhide the data. Can I (you!) write a formula that will unhide my data on January 1st? Thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding rows depending on the date
There is no 'custom autofilter' in the autofilter choices. . .
"Teethless mama" wrote: Data Filter AutoFilter Custom AutoFilter Select date is less than 1/1/2007 OK "Jan Buckley" wrote: I have some hidden rows that I would like to become visible on january 1st. I will not be available to manually unhide the data. Can I (you!) write a formula that will unhide my data on January 1st? Thanks in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding rows depending on the date
Have you not got an option labelled (Custom ...), occurring 3rd in the
dropdown list, after (All) and (Top 10...)? What version of Excel are you using? -- David Biddulph "Jan Buckley" wrote in message ... There is no 'custom autofilter' in the autofilter choices. . . "Teethless mama" wrote: Data Filter AutoFilter Custom AutoFilter Select date is less than 1/1/2007 OK "Jan Buckley" wrote: I have some hidden rows that I would like to become visible on january 1st. I will not be available to manually unhide the data. Can I (you!) write a formula that will unhide my data on January 1st? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recalculation on hiding rows in Excel 2003 | Excel Discussion (Misc queries) | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
| Automatically Hiding Blank Rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
