Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Since your col headers in B1 across appear to be real dates:
The top of the column is like this ( B1) "Monday, November 17, 2008" (C1) "Tuesday, November 18, 2008" and so on The earlier expression simplifies to this In A1, copied down: =IF(ISNA(MATCH(TODAY(),$B$1:$IV$1,0)),"",OFFSET(B$ 1,ROWS($1:1)-1,MATCH(TODAY(),$B$1:$IV$1,0)-1)) Format the header A1 as date to taste. Hide away cols B to IV so that these, in your own words, doesn't distract. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "CevaClerkII" wrote: It's close, but the data entered from previous days are still visible. This has proven to be a distraction from the task at hand. The top of the column is like this ( B1) "Monday, November 17, 2008" (C1) "Tuesday, November 18, 2008" and so on. Below, sensitive details of every hour are entered. I would like to hide the previous days columns. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide columns and rows | Excel Worksheet Functions | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
Hide rows or columns using + - buttons | Excel Discussion (Misc queries) | |||
Auto Hide Columns & Rows | Excel Discussion (Misc queries) |