close

I have a worksheet with dates across the top with information relevent to
that date beneath. What I wish to do is transfer the information for todays
date only to another sheet that will update itself as the date changes.Can
anyone help.

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
www.rondebruin.nlquot;KandKquot; gt; wrote in message ...
gt;I have a worksheet with dates across the top with information relevent to
gt; that date beneath. What I wish to do is transfer the information for todays
gt; date only to another sheet that will update itself as the date changes.Can
gt; anyone help.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()