Hide Rows & Columns by date
 

I have created a work sheet with five columns, one for each day in the work
week. I want to hide the columns that are not the current day. I only need to
see the current day.
--
Thanks CevaClerkII

Hide Rows & Columns by date
 

One lateral idea ..

Assume the 5 "day" col labels in C1:G1 are text:
Mon, Tue, Wed, Thu, Fri
with source data running in row2 down

Place in A1:
=IF(ISNA(MATCH(TEXT(TODAY(),"ddd"),$C$1:$G$1,0))," ",OFFSET(C$1,ROWS($1:1)-1,MATCH(TEXT(TODAY(),"ddd"),$C$1:$G$1,0)-1))

Copy A1 down to cover the max expected extent of source data in cols C to G.
Col A will always return the required "Current day's" col. So you could hide
away cols C to G. As empty source cells will show as zeros in col A, for a
neater look you could suppress this via clicking Tools Options View tab,
uncheck Zero values OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"CevaClerkII" wrote:
I have created a work sheet with five columns, one for each day in the work
week. I want to hide the columns that are not the current day. I only need to
see the current day

Hide Rows & Columns by date
 

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.
--
CevaClerkII


"Max" wrote:

One lateral idea ..

Assume the 5 "day" col labels in C1:G1 are text:
Mon, Tue, Wed, Thu, Fri
with source data running in row2 down

Place in A1:
=IF(ISNA(MATCH(TEXT(TODAY(),"ddd"),$C$1:$G$1,0))," ",OFFSET(C$1,ROWS($1:1)-1,MATCH(TEXT(TODAY(),"ddd"),$C$1:$G$1,0)-1))

Copy A1 down to cover the max expected extent of source data in cols C to G.
Col A will always return the required "Current day's" col. So you could hide
away cols C to G. As empty source cells will show as zeros in col A, for a
neater look you could suppress this via clicking Tools Options View tab,
uncheck Zero values OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"CevaClerkII" wrote:
I have created a work sheet with five columns, one for each day in the work
week. I want to hide the columns that are not the current day. I only need to
see the current day

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.