LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide columns and rows delete automatically Excel Worksheet Functions 2 September 25th 07 12:49 AM
Hide / Unhide columns and rows PaulM Excel Discussion (Misc queries) 8 September 6th 07 12:14 AM
How to hide and unhide Rows & Columns Aarif Excel Worksheet Functions 3 March 23rd 06 05:19 AM
Hide rows or columns using + - buttons [email protected] Excel Discussion (Misc queries) 2 July 6th 05 02:56 PM
Auto Hide Columns & Rows appeng Excel Discussion (Misc queries) 2 March 25th 05 04:43 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"