Transfer only information under todays date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top