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.
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.
文章標籤
全站熱搜
