Transfer only information under todays date
 

I have a worksheet which has numerous entries under sequential dates. I want
to just transfer the information under todays date to a different sheet where
the information will change as the date changes. Can anybody help.

Transfer only information under todays date
 

Hi KandK

You can use this formula for the cell value in row 2 with the dates in row 1
Change this range to yours
Sheet1!$A$1:$J$400

=HLOOKUP(TODAY(),Sheet1!$A$1:$J$400,2,FALSE)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"KandK" wrote in message ...
I have a worksheet which has numerous entries under sequential dates. I want
to just transfer the information under todays date to a different sheet where
the information will change as the date changes. Can anybody help.