Hi Al

Use this tip to fill the dates in the empty cells in column U
http://www.contextures.com/xlDataEntry02.html

Now you can use Autofilter



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Al" wrote in message ...
Im not sure I understand....

For instance
A B C U
5 1/24/2007
6
7
8
46
47 1/25/2007
48
49
50
88
89 1/26/2007

Today I only want to see rows 5-46
Tomorrow rows 47-88 etc.
By Filter or Macro I just dont know how to do it..

Hope this clears it up some

Thanks!



"Ron de Bruin" wrote:

Hi Al

You can autofilter on the date

Date in U5
Is this the date you want to see ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Al" wrote in message ...
Hello
I have a daily data sheet that is laid out as follows Date in U5 and data
entered in rows 6-46. I would like to make a months worth of sheets on one
worksheet repeating the samel ayout. How can I hide all rows except for the
current day?
Thanks!