View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Hide Rows & Columns by date

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.