Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 29th 09, 06:43 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 54
Default auto hide data

I want to do any of following thing

(1) On day2 when I open excel sheet, data that i entered on day1 in
perticular sheet (say sheet1) should be hidden automatically.
Or
(2) On day2, when I open excel sheet & enter today's date on sheet1,
data entered on day1 should go hidden.

i want to do this daily basis.
Pls also tell me how to unhide this.

thanks an advance


  #2   Report Post  
Old May 29th 09, 07:51 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 245
Default auto hide data

Possibly, all you need to do is Data filter but you may need to use VBA
programming language.

Data filter:
XL2003
http://office.microsoft.com/en-us/ex...CH062527971033

XL2007
http://office.microsoft.com/en-us/ex...CH100648451033

You filter would be:
- select (Custom...)
- change the date drop-down to 'is less than'
- write the day's date



A VBA solution should be relatively easy for someone familiar with VBA
however, you will need to give some idea of data layout and what you wish to
see each day. For example, you talk about day 1 data being hidden on day 2.
What happens on day 3? Unhide day 2? On day 213? In other words, are you
really looking to hide all previous date's data? A data layout would be
useful. Example:

Date, Product, Qty, Price, Total



The macro to hide data laid out this way would be

Sub HideData()
ActiveSheet.AutoFilterMode = False
Range("A2").Select ' a cell below your headings
Selection.AutoFilter Field:=1, Criteria1:="=" & --Format(Date, "0"),
Operator:=xlAnd

'Field:= 1' would be the date field if in column A
'change to Field:= 2 if date in column B, 3 if Column C, etc.

End Sub


To use the above:
-right-click the tab or the relevant worksheet
- copy and paste the code









--
Steve

"aditya" wrote in message
...
I want to do any of following thing

(1) On day2 when I open excel sheet, data that i entered on day1 in
perticular sheet (say sheet1) should be hidden automatically.
Or
(2) On day2, when I open excel sheet & enter today's date on sheet1,
data entered on day1 should go hidden.

i want to do this daily basis.
Pls also tell me how to unhide this.

thanks an advance



Reply
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
auto hide data aditya Excel Discussion (Misc queries) 1 May 29th 09 10:59 PM
Want to Hide columns in spreadsheet but NOT hide data in chart. KrispyData Charts and Charting in Excel 1 March 20th 09 05:45 PM
auto hide Chad Excel Discussion (Misc queries) 9 February 19th 09 08:34 PM
Auto Hide Columns when... Jase4now Excel Discussion (Misc queries) 0 March 28th 07 07:02 PM
Want to auto hide rows in excel when no data in a certain column. Tim Excel Discussion (Misc queries) 3 June 30th 05 12:52 AM


All times are GMT +1. The time now is 11:23 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017