On Friday, January 9, 2015 at 10:49:10 PM UTC-6, Kefo wrote:
Ok So I am at loss on how to do this. I have an excel sheet that
everyday the date is entered and adjacent cells have some data
displayed(see my example below).

What I want to do is when a user enters the data for the new day then 1
row is hidden so that only 365 days of data is actually displayed. The
sheet I attached has less then 2 weeks present just to give you an idea
of what everything looks like but obviously with the goal of going back
365 days.


A B C D
E
Date Julian Date Product Code Product Name Comments
09-Jan-14 4009 1234567 Testing
testing
10-Jan-14 4010 2345678 Test
test
.........
09-Jan-15 5009 3456789 Testin
Testin

So when someone enters 10-Jan-15 it will automatically hide all the data
associated with 09-Jan-14 so that 10-Jan-15 will be at the top of the
sheet and continue to do so as each new day is entered.

Thanks for your help in advance




--
Kefo

Are you saying you ONLY want to show the latest date, or only show the latest entry or EXACTLY what do you want. Easy to do with a worksheet change event macro.